Problem is when ever i try to bind the gridview using the Sql data source and calling SP.
Its not displaying anything on the screen, where as i tested the SP, its working fine.
But when i write the Select statement in Sql data source... Its working fine.
[Code]....
I am trying to bind a table to my grid view. This grid view has an extra column Serial Number where I want to show numbers starting from 1 till the last entry.
View 4 RepliesI am developing an application using ASP.NET with C#.NET.in my application i have a gridview control and radobutton list having the values as Manufacturer and Distributor. based on the radiobutton selected value,the gridview will bindedup.
i am using SQL SERVER 2005 as backend server. in my database i have one table with columns as
1.mfropendate
2.mfrclosedate
3.mfrawarddate
4.distopendate
5.distclosedate
6.distawarddate
My gridview has 3 columns as Opendate,closedate,awarddate.
if user select the radiobutton as manufacturer,only mfropendate,mfrclosedate,mfrawarddate have to bind. and if user select the distributor the remaining 3 fields will have to bind. for that i had write a storedproc as create procedure sp_GetDraftBids as begin select mfropendate as opendate,mfrclosedate as closedate,mfrawarddate as awarddate, distopendate as opendate,distclosedate closedate,distawarddate awarddate from draftbids end GO
i.e i had taken the alias names for that fields so that i will bind the only 3 columns to grid view as opendate,closedate,awarddate.
My gridview code is
[Code]....
here i had taken the same alias names as i have to bind only 3 columns to gridview.when i run my application i am getting the records in data table with column names as opendate,closedate,awarddate,opendate1,closedate1,awarddate1.i.e it does not allow the same alias name.
for two radio button conditions i.e for manufacturer and distributor the gridview binded with opendate,closedate and awarddate columns as i had binded the gridview boundfields withat names.
but when user select the distributor radiobutton i have to bind the opendate1,closedate1 and awarddate1 to the gridview. for that should i can i change the storedproc are any other solution is there?
I retrieving user selected values from my first page with session.
I need to list product details whcih user selected separately. I mean if user selected
Products 1,5,7 Second page listing product details separately 1,5,7 in gridview1, gridview2, gridview3.
When I click on edit button I am expecting it to change like a text box and let me edit the content. But it is not happening. Can you see my code and let me know What I am missing?
<asp:GridView ID="gvSearch" runat="server" AutoGenerateColumns="False" AllowPaging="True"
AllowSorting="true" Width="650px" PageSize="20" OnRowCommand="gvSearch_RowCommand" OnRowDataBound="gvSearch_RowDataBound"
OnRowEditing="gvSearch_RowEditing" OnRowUpdating="gvSearch_RowUpdating"
>
<Columns>
<asp:TemplateField HeaderText="User Id" SortExpression="User Id">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblusrId" runat="server" Text='<%# Eval("UserId")%> '></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="First Name" SortExpression="FirstName">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblFname" runat="server" Text='<%# Eval("FirstName")%> '></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Last Name" SortExpression="LastName">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblLname" runat="server" Text='<%# Eval("LastName")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MiddleName" SortExpression="CreatedOn">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblMname" runat="server" Text='<%# Eval("MiddleName")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Employee Id" SortExpression="EmployeeId">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblEmpId" runat="server" Text='<%# Eval("EmployeeId")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User Status" SortExpression="NetId">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblUsrStatus" runat="server" Text='<%# Eval("UserStatus")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="View User Details" SortExpression="View">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<ItemTemplate>
<asp:LinkButton ID="lbView" Text="View Details" runat="server" CommandName="View" CommandArgument='<%#Eval("FirstName")+";"+Eval("LastName")+";"+Eval("UserId")%>' ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="View User Details" SortExpression="View">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<ItemTemplate>
<asp:LinkButton ID="lbledit" Text="Edit" runat="server" CommandName="Edit" CommandArgument='<%#Eval("FirstName")+";"+Eval("LastName")+";"+Eval("UserId")%>' ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected void gvSearch_RowCommand(object source, GridViewCommandEventArgs e)
{
if (e.CommandName == "View")
{
string arg = Convert.ToString(e.CommandArgument);
// Response.Redirect("~/CFEmpDetails.aspx?arg=" + arg);
}
if (e.CommandName == "Edit")
{
}
}
protected void gvSearch_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
}
}
protected void gvSearch_RowEditing(object sender, GridViewEditEventArgs e)
{
}
protected void gvSearch_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
I want to bind a grid view by code not by wizard.
View 2 RepliesMy requirement is i want to bind data to gridview2 which is placed in gridview1..Iam using EDM objects to refer database...So for Gridview1 Iam getting out put...now how to bind to gridview2...For gridview1 I binded the data which is in onetable...And for gridview2 i want to bind MENU table data...so how can i bind the data...
this is the gridview2..in gridview1 row.
[Code]....
I also tried using FindControl() but iam not able to proceed further.
I have a grid view and I added edit and Save buttons to it. When I click on edit I am able to edit the data but when I click on save I amgetting the data before edit.
Please see my code below.
Eg: I have start date as 2005-10-10 12:00 AM so After I click On edit it is letting me to edit, So If I edit the start date to 2010-10-10 12:00 PM and click on the save button I am stil getting the old start date. which is 2005-10-10 12:00 AM instead of 2010-10-10 12:00 PM
<asp:GridView ID="gvPosHistory" runat="server" AutoGenerateColumns="False" AllowPaging="True"
AllowSorting="true" Width="650px" PageSize="20" CssClass="Gridview" Visible="false"
OnRowCommand="gvPosHistory_RowCommand"
OnRowDataBound="gvPosHistory_RowDataBound"
OnRowEditing="gvPosHistory_RowEditing"
OnRowUpdating="gvPosHistory_RowUpdating"
onrowcancelingedit="gvPosHistory_RowCancelingEdit" >
<Columns>
<asp:TemplateField HeaderText="Start Date" SortExpression="startDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblstartdate" runat="server" text='<%# Eval("StartDate")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtStartDate" runat="server" Text='<%# Bind("StartDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="End Date" SortExpression="endDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblenddate" runat="server" text='<%# Eval("EndDate")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtEndDate" runat="server" Text='<%# Bind("EndDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Functional Job Title" SortExpression="JobTitle">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblFunctjobTitle" runat="server" text='<%# Eval("FunctionalJobTitle")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtFuncJobTitle" runat="server" text='<%# Bind("FunctionalJobTitle")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Department" SortExpression="Department">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblDepartment" runat="server" text='<%# Eval("DeptName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtDeptName" runat="server" Text='<%# Bind("DeptName")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Supervisor" SortExpression="Supervisor">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblSupervisor" runat="server" text='<%# Eval("Supervisor")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtSupervisor" runat="server" Text='<%# Bind("Supervisor")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Bargaining Unit" SortExpression="bargainingunit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblbargainingunit" runat="server" text='<%# Eval("BargainingUnit")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtBargainingUnit" runat="server" text='<%# Bind("BargainingUnit")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="UCP Level" SortExpression="UCPlevel">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblUCPlevel" runat="server" text='<%# Eval("UCPLevel")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtUcpLevel" runat="server" Text='<%#Bind("UCPLevel")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" SortExpression="Edit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<ItemTemplate>
<asp:LinkButton ID="LBPosHistoryEdit" Text="Edit" runat="server" CommandName="Edit" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Save" SortExpression="Save">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<EditItemTemplate>
<asp:LinkButton ID="LBPosHistorySave" Text="Save" runat="server" CommandName="SavePosHistory" CommandArgument='<%# Eval("UCPLevel")%>' ></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
.aspx.cs
protected void gvPosHistory_RowCommand(object source, GridViewCommandEventArgs e)
{
if (e.CommandName == "SavePosHistory")
{
string arg = Convert.ToString(e.CommandArgument);
System.Web.UI.WebControls.LinkButton btnPosHistory = e.CommandSource as System.Web.UI.WebControls.LinkButton;
GridViewRow row = btnPosHistory.NamingContainer as GridViewRow;
TextBox tSdate = row.FindControl("txtStartDate") as TextBox;
TextBox tEdate = row.FindControl("txtEndDate") as TextBox;
TextBox tFuncJobTitle = row.FindControl("txtFuncJobTitle") as TextBox;
TextBox tDeptName = row.FindControl("txtDeptName") as TextBox;
TextBox tSupervisor = row.FindControl("txtSupervisor") as TextBox;
TextBox tBargainingUnit = row.FindControl("txtBargainingUnit") as TextBox;
TextBox tUCPLevel = row.FindControl("txtUcpLevel") as TextBox;
}
}
I have a grid view and I am unable to get the values that I edited from the grid view using below code. Can Any one look into it and advise what is wrong with my code?
View 11 Repliesi have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view
View 5 RepliesIt happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .
Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically behaviour of both the events in !Postback and page.Postback .
I am doing a online web application whereby user is able to enter in new template as well as search for template. The Add template is located outside the grid view and if user clicks on the button, it will load the grid view that is populated with data as there is a row of empty fields at the bottom. However when I click on the Add Template button, the grid view does not appear.
This is my business logic that I used it to search for records as well to click on the Add Template button to add in new records:
[Code]....
[Code]....
[Code]....
i have a grid view which displays only one value and i need to extract that value and display it in a textbox?
View 4 Repliesusing for Loop I bind data to data table
DataTable dt = new DataTable();
DataColumn dcIn = new DataColumn("IN");
DataColumn dcOut = new DataColumn("OUT");
DataColumn dcDuration = new DataColumn("DURATION");
dt.Columns.Add(dcIn);
dt.Columns.Add(dcOut);
[code]...
I just want to bind controls to the grid view but i want to do it dynamically.As an example i just want to enter students marks to text box to adjacent subjects??
thinks students are in row's and subjects are in columns and it similar to matrix in mathematics . but some times no of students and no of subjects are vary.
i am wking on an assignment in which i have a gridview that contain deptno in a dropdownlist.by selecting a particular deptno from that dropdownlist,the number of employee of that department displayed in second dropdownlist that is for displaying employyee of a department.And after selecting the employee its salary detail and date of joining displayed in textboxes?we have two database table one is for employee(fields are deptno,empname,salary,joining date,status(true/false))and second department(fields are deptno,deptname,location);;;
View 1 RepliesIn asp.net Grid view control whether it is possible to bind the data to the cell of gridview without using SQL or SQL connection
View 1 RepliesI have two tables in my database
using "innerconnect" i have show table content in grid view as INV_NO INV_DT DN_NO DN_DT LR_NO LR_DT .
where LR_NO is null .
I want to update it from grid view.
here DN_NO and INV_NO are primary keys
[Code].....
when i have fill the null values through grid view and click on button1 it shows data saved but it not saves to my data base tables
Have a GridView with a templated select button hidden and using
e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .
When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .
I have a grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.
View 4 Repliesspeed Performane i create a web site but it very slow run i use tree view and grid view but i do it run very fast
View 1 Repliesi have gridview , it contains record of productsname field of product table and hyper link, hyperlink named as Detail.
when i click Detail link ,it will show record of that row in another page,means it shows complete fields of table in another page,,
i want to know only that,how detail link will perform,to view only that row record,
i'm tring to search my table according to id number or the case number then view it in a gridviewbut it work for the first time then after it stop for error
Dim conn As New SqlConnection
conn.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATATask.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[code]...
i have created a simple view, and display it into gridview.. i have successfully created view but it is not shown in grid view , it return nothing...
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=E:
arenHDI-AJAX-TK-Calendar-CSApp_DataDatabase.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from nview", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
Is there any way to bind my grid from javascript.
How can I do this in asp.net?