.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
AndyV
webmaster
SOHINI DASGUPTA
Post New Web Links

binding to item template label of a gridview from stored procedure result of common column names

Posted By:      Posted Date: November 01, 2010    Points: 0   Category :Sql Server
 

hi  my stored procedure contains a joining result of different tables with common column name to a dataset result can bind to gridview

as follows

CREATE proc SppShowStock 
as 
begin  

select p.id, p.ProductId,  p.ProducName,  sh.CompanyName ,  su.CompanyName

 from  
TblStock p inner join TblSupplier su on p.SupplierId=su.CompanyCode 
     inner join TblShipper sh on p.ShipperId=sh.shipperid   
           inner join  TblCategory c on p.Category=c.Id 

end

<asp:TemplateField HeaderText="id">
                <ItemTemplate>
                    <asp:Label ID="lblid" runat="server" Text='<%# Eval("id") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>

 

i am little bit in confusi


View Complete Post


More Related Resource Links

Its posible to do a select without the table and the column names into a stored procedure?

  

Hello!!

I need your help. Imagine that I have two tables:

  1. ALUMN wich has three columns: IdAlumn, Name and Address.
  2. SPORT wich has columns: IdSport, Name, Players and Description.

Supose that my tables could be differnced by a number 1 is for ALUMN and 2 is for SPORT.

And the columns of each table too. So 1 is for IdAlumn, 2 is for Name and 3 is for Address. 1 is for IdSport, 2 is for Name 3 is for Players and 4 is for Description.

For example the combination of table 2 and column 3 is SPORT-Players.

Then I want to do an stored procedure that receives two parameters (the table, the column) @tab and&

Stored Procedure Column Names - A Suggestion

  

When a data source calls a stored procedure, you often don't see the column names exposed for mapping in the dataflow designer. There are a number of work-arounds involving SET FMTONLY OFF or setting up a dummy select statement early in the stored procedure, non of which are entirely satisfactory.

Perhaps the SSIS developers could learn something from SSRS here, after the data from a datasource is previewed, the column names are available in the Report Desginer no matter how complex the stored procedure might be.

I would have thought that when you preview the data from the strored procedure in BIDs, that all the required information about the column names and data types returned by the stored procedure could be captured and made available in the data flow designer.


Creating A Stored Procedure Which Searches Team Names

  

Hi

I'm have on my web page a text search box which I want users to type in there favourite football team and this will display a gridview of the teams with the replica shirts I offer.

This is where I thought about creating a stored procedure to carry out this task.

I looked online for ideas but I not found anything as yet.

If anyone done anything similar to my request please let me know.



Sort by gridview SortExpression parameter via Stored Procedure

  

I have a gridview that calls data via a stored procedure.  I am unable to enable the gridview columns to be sortable. I need to set the parameter in the Stored Procedure, can someone help me with this?

Here is my gridview:

<asp:GridView ID="AllUsersGrid" runat="server" AutoGenerateColumns="False" DataKeyNames="UserName"
                        GridLines="Vertical" Width="900px" DataSourceID="SqlDataSource1" AllowSorting="True"
                        SelectedRowStyle-Height="30px" CellPadding="4" BackColor="White">
                        <Columns>
                            <asp:TemplateField HeaderText="Full Name" SortExpression="lastname">
                                <ItemTemplate>
                                    <asp:Label ID="DisplayName" runat="server" Text='<%# Eval("firstname").ToString() & " " & Eval("lastname").ToString() %>' />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField HeaderText="User Name" DataField="UserName" />
                            <

Error Executing CLR Stored Procedure "Item has already been added. Key in dictionary"

  
Hello, I'm consuming a web service through assemblies in a Sql Server 2005 database. The client was made with VB.net 2005. Everything was fine in the deploy phase but once I compile the assembly generated in my sql server database and try to execute the CLR stored procedure defined in the assembly it crashes throwing the following error: Error: There was an error generating the XML document. Inner Exception: Item has already been added. Key in dictionary: 'SqlCifin.InfoComercial.ParametrosConsultaDTO' Key being added: 'SqlCifin.InfoComercial.ParametrosConsultaDTO' Where SqlCifin is the name of the assembly, InfoComercial is the web reference namespace and ParametrosConsultaDTO is a complex type defined in the WSDL to encapsulate the request parameters. I tried almost everything but nothing seems to work: Already checked the enviroment variables and . I would appreciate any help you can provide me.  PD: I'm using WSE 3.0. Thanks, Andres Diab.

Binding Web Service Result in asp:gridview and enable sorting(paiging)

  
Hello everyoneI have web service and gridviewI'm binding it without problemcode: protected void Page_Load(object sender, EventArgs e) { GetCallsService wservice = new GetCallsService(); List<Call> list = wservice.getCalls(2); GridView1.DataSource = list; //GridView1.AllowSorting = true; GridView1.DataBind(); } But I want to enable sorting and(or) paging.   GridView1.AllowSorting = true; this doen't solves problem.everything worls fine if I'm usign sqlDatasource but when datasource is web service it doesn't wokdoes enyone know solution?

want to create common Stored procedure

  
Hello, I have more than 20 tables, for this i want to create a common Stored procedure which fetches data by id Column So I tried like this,but it doesnt work ALTER PROCEDURE [dbo].[ERS_SP_GetAllTableDataByID] -- Add the parameters for the stored procedure here @TableName nvarchar(100), @ColumnName nvarchar(100), @ColumnVal nvarchar(100) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here DECLARE @ExecQuery nvarchar(100) SET @ExecQuery =@TableName -- Insert statements for procedure here select @ExecQuery = 'SELECT * FROM [' + @TableName + '] WHERE ' + '[' +@ColumnName +']=' + @ColumnVal exec (@ExecQuery) END please help me out Regards,

Update Database Record using GridView and Stored Procedure

  
Hi, I am trying to update record via stored procedure, but i got error at very start point. Problem is when i click on Edit link button within the Gridview it produce error. I can populate values from database fine but its produce error when i click on edit link button. Please see the code below. *********** ASP.net GridView Code I am using *****************<asp:GridView ID="GridView1" runat="server" DataKeyNames="RollID, EmpID" AutoGenerateColumns="False" Width="700px"> <Columns> <asp:TemplateField HeaderText="ApplicationID" Visible="false"> <ItemTemplate> <asp:Label ID="AppsID" runat="server" Visible="false"><%# Eval("RollID") %>'</asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="ReleaseID" Visible="false"> <ItemTemplate> <asp:Label ID="rlsID" runat="server" Visible="false"><%# Eval("EmpID") %></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Roll Name"> <ItemTemplate> <asp:Label ID="rlsVersion" runat="server"><%# Eval("Roll_Name")%></asp:Label> </ItemTemplate> <EditI

Exception when applying a policy against stored procedure names...

  
Hi There,       I have recently created a policy that checks stored procedure names and prevents any to be created and/or changed to anything that is not prefixed with 'spr_'. I have a simple Cindition called SPNameCondition who's expression is @Name LIKE 'spr_%' I also have my Policy called SPNamePolicy who's condition is set to SPNameCondition. It is Enabled and targets every stored procedure in every database. I have the evaluation mode set to on change: prevent and no server restrictions. After creating my policy, I checked it by evaluating it against all existing stored procedures in our databases. This worked as I expected as it flagged up all existing stored procedures names that didn't start with 'spr_' as in error. The problem I am having though, is when I create a new stored procedure in SSMS and execute I get the following exception: A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_execute_policy": System.TypeInitializationException: The type initializer for 'Microsoft.SqlServer.Management.Dmf.PolicyEvaluationHelper' threw an exception. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file spe

How can I replace values in GridView returned from a Stored Procedure

  
I am working on creating a stored procedure that will output a pivot table.  In the pivot table will be either the string NULL or a number.  How can I reformat this in ASP.NET so the NULL value becomes a blank cell in the gridview and the number (whatever it is) becomes an 'X' ?

gridview item template

  
Hi, I have a gridview which the columns are created programmatically.When a button is click i will clear all columns and add the columns that I want. Im adding a boundfield which is not a problem. When I add a template field, I must add also the item template which is my problem.How can I add a item template in the template field I created which is binded in my datasource. Also what event handler should I use to do this.Here's the part of my code:Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click GridView1.Columns.Clear() Dim en As New BoundField en.HeaderText = "Employee Number" en.DataField = "Employee Number" GridView1.Columns.Add(en) Dim n As New TemplateField n.HeaderText = "Name" GridView1.Columns.Add(n) AccessDataSource1.SelectCommand = "Select * from Employee" GridView1.DataBind() End Sub Someone know how can  I bind a label item template from the datasource. The label item template should be firstname + middlename + lastname.If im not doing it programatically, it will be just concatenating eval(). But how can create item template and bind it programmatically??.

Gridview and stored procedure

  
Hi,   I am returning a list of machines to a gridview by rental packageID, the the rental packageID shows a rental amount in a new column.   E.g. Rental Package ID Annual Rental           1                            5,000           1                            5,000           2                            1,000   The problem is that for any machine where the rental packageID is the same as another, the annual rental shows the value twice, this is a problem as the footer in the griview calculates the total of the column and its bringing incorrect values.   Does anyone know how to fix this is my stored procedure?  

GridView column/row data binding problem

  
Hi All, I have a table with the following structure: Attribute------------- AttributeIdWeekNoDayNoAttribute1Attribute2Attribute3Attribute4Attribute5 ........ likewise. I want to display these data in a gridview in the following manner                                  Sunday    Monday Tuesday ............ (till Saturday) - should be gridview columns, I can retrieve this using dayno Attribute 1 Attribute 2 Attribute 3 Attribute 4 .......... like wise attributes should be taken in to rows.Is this possible in a gridview, if so how can I do that?

Combine Common Code in Stored Procedure

  
I have the following stored procedure: ALTER PROCEDURE dbo.tc_TopicsGetTopics ( @StartRow int, @MaxRows int, @LocationID int, @GroupID int ) AS BEGIN SET NOCOUNT ON -- Return topics IF @GroupID <> 0 BEGIN WITH TopTemp AS (SELECT TOP (@StartRow + @MaxRows) ROW_NUMBER() OVER (ORDER BY TopCreated DESC) AS RowID, TopID, TopTitle, TopCreated FROM Topics WHERE TopGroupID = @GroupID) SELECT TopID, TopTitle, TopCreated FROM TopTemp WHERE RowID BETWEEN @StartRow + 1 AND (@StartRow + @MaxRows) ORDER BY RowID END ELSE BEGIN WITH TopTemp AS (SELECT TOP (@StartRow + @MaxRows) ROW_NUMBER() OVER (ORDER BY TopCreated DESC) AS RowID, TopID, TopTitle, TopCreated FROM Topics WHERE TopLocationID = @LocationID) SELECT TopID, TopTitle, TopCreated FROM TopTemp WHERE RowID BETWEEN @StartRow + 1 AND (@StartRow + @MaxRows) ORDER BY RowID END RETURN END Two questions: 1. Is there a simple way to move the two identical SELECT statements out of the IF statement so it would only need to appear once in the procedure? I assume I could create a temporary table. Is that the same as using WITH? 2. Does anyone see much reason to do what I'm asking? Would it affect storage or efficiency? Thanks!  Jonathan Wood • SoftCircuits • Developer Blog

insert result of stored procedure in new table

  
hi how can i insert the result of stored procedure in the new table. Best Regards. Morteza

update stored procedure for existing values of column(salperyr)

  
tbl_salary salary           salperyr   hike20      hike20yr10000.0000    NULL      12000.00    144000.0012000.0000    NULL      14400.00    172800.0014000.0000    NULL      16800.00    201600.0015000.0000    NULL      18000.00    216000.0018000.0000    NULL      21600.00    259200.0020000.0000    NULL      24000.00    288000.0022000.0000    NULL      26400.00    316800.00in above table salaryper yr (salperyr) has to be modified after caliculation my null values has to be removed and place (salary*12)in one shot.so plz suggest me update stored procedure for this.

update stored procedure for existing values of column(

  
tbl_salary salary            salperyr    hike20       hike20yr 10000.0000    NULL      12000.00    144000.00 12000.0000    NULL      14400.00    172800.00 14000.0000    NULL      16800.00    201600.00 15000.0000    NULL      18000.00    216000.00 18000.0000    NULL      21600.00    259200.00 20000.0000    NULL      24000.00    288000.00 22000.0000    NULL      26400.00    316800.00 in above table salaryper yr (salperyr ) has to be modified after caliculation my null values has to be removed and place (salary*12 )in one shot.   so plz suggest me update stored procedure for this
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend