i have panel & i m trying to bind it with data table
as panel has no datasource property. can anyone solve it out.
DataTable dt=new DataTable ();
DataRow dr = dt.NewRow();
dr["serviceid"] = ddlservices.SelectedValue.ToString();
dt.Rows.Add(dr);
foreach (DataRow row in dt.Rows)
{
PanelBody.Controls.Add(row);
PanelBody.DataBind();
}
I have one repeater control in my web page.
And i want to bind this repeater control from button.
But button is in Update panel in ajax.
And repeater control is outside the updatePanel...
I need to display the softwares expired validating it with current date.....
but when i fill the dataset and displaying the data in a label.
suppose i have retrieved 3 softwares but i have already put 10 labels to show first 10 expired softwares
iam getting a error on 4th label as it is empty so wat condition should i mention to overcome this problem...
my sample code----
Dim cmd As SqlCommand = New SqlCommand("select distinct productname from productinfo where expirydate > ='" + localdate + "' ", conn) Dim dalogin As SqlDataAdapter = New SqlDataAdapter(cmd) Dim dtlogin As DataSet = New DataSet() dalogin.Fill(dtlogin) If (dtlogin.Tables(0).Rows.Count > 0) Then lblexpiry1.Text = dtlogin.Tables(0).Rows(0).Item(0) If dtlogin.Tables(0).Rows(1).Item(0) Is Nothing Then td1.InnerHtml = "" Else Label1.Text = dtlogin.Tables(0).Rows(1).Item(0) End If If dtlogin.Tables(0).Rows(2).Item(0) Is Nothing Then td1.InnerHtml = "" Else Label2.Text = dtlogin.Tables(0).Rows(2).Item(0) End If If dtlogin.Tables(0).Rows(3).Item(0) Is Nothing Then td1.InnerHtml = "" Else Label3.Text = dtlogin.Tables(0).Rows(3).Item(0) End If Label4.Text = dtlogin.Tables(0).Rows(4).Item(0) Label5.Text = dtlogin.Tables(0).Rows(5).Item(0) Label6.Text = dtlogin.Tables(0).Rows(6).Item(0) Label7.Text = dtlogin.Tables(0).Rows(7).Item(0) Label8.Text = dtlogin.Tables(0).Rows(8).Item(0) Label9.Text = dtlogin.Tables(0).Rows(9).Item(0) End If
I have a data table, in one of the column, I will have this data, I will bind the data table to a grid view. I was hoping that this column change to a hyperlink. But, it was display the entire text.
<A HREF="page_url">Remark(s)</A>
When I view the page source code, I saw this:
<A HREF="page_url;Remark(s)</A>
How to correct this?
[URL]
like above link i want to bind
name.....................
city...... country.........
for suppose 10 employee. for that i try to bind datalist using webservice & jquery. but i get lots of problem to bind datalist. with name as hyperlink so that when i click at name it go to next page and show details.
I need a bit of help with a scenario. I am working on a web application that requires huge amounts of data to be Added, Deleted, and Updated. The data entry forms are divided into logical groups through Multiviews. All the information is saved when the mighty Finish button is pressed. The current setup (previous developer) does not allow me to use transactions. Therefore, if I am to save a new Courier to the database, I need to add his/her Distance and Rate info. In addition, I need to add his/her Banned Areas info (Area Name, Post Code).This is where it gets interesting. Obviously, the DistamceAndRate table and the BannedArea table in my SQL Server will have the CourierID as a foreign key. Since I'm going to save the Courier as well as the Rates and Areas info in one go, I cannot have the newly created CourierID before. Therefore, I cannot bind my Grids for Distance + Rates and Banned Areas directly to database.What I am doing is creating two DataTables and managing them in Viewstate through properties as follow:
[Code]....
So, on page load, the DataTables are initialized with a blank schema. Here are the attempted CRUD implementations (Distance and Rate only):
[Code]....
I am having issues when I am canceling a new entry and when I am editing a new entry. In addition, for Distance and Rates, Rate is acting as unique (cannot be repeated) and attempting to control that is also giving me a headache. I end up creating blank rows.And here's the ASPX cut-out:
[Code]....
Hope to get an answer soon.Also, off-topic, I'm using LINQ here. In order to save a Courier and his/her extra details, I first save his/her address to DB. Then I take the ID of the address and save the courier. now the courier ID is avaliable and i start filling extra tables related with the courier table. If something goes wrong, I have to manually delete created rows. LINQ uses transaction internally but only until a SubmitChanges() call. I'm forced to save each entity so I keep calling SubmitChanges().I tried manual transaction but after saving the address inside a transaction, the Address.OID (Address table's mapped prime-key) had a 0. attempting to use this newly added address while saving Courier in the same transaction threw an exception. If there is a way to get the primary key for entities created in a transaction that is yet to be commited, please mention that'll as well.
I want to know how to bind a FormView from the code behind with a datatable.
View 1 Replieshow to bind the value to gridview
i have a datatable
DataTable dtBindGrid = new DataTable();
dtBindGrid = serviceobj.SelectExamTimeTable(txtSchoolName.Text, txtBranchName.Text, txtClass.Text, txtExamName.Text);
foreach (DataRow row in dtBindGrid.Rows)
{
[Code]....
this datatable will return me some values like day,date,time,duration,subject,..
here im getting each value in string bec to convert the Time as 9.00am or 9.00pm
DatedTime = Convert.ToDateTime(row["Time"].ToString());
strgettime = DatedTime.ToString("t");
.... how to bind this converted value to my gridview.
is it possible to bind DataTable to ObjectDataSource?
View 4 RepliesI would like to bind 'Id', 'Name' and 'Email' from DataTable to RadComboBox. It's possible with ItemTemplate. But I don't want to display 'Email' column in the RadComboBox. I want display 'Email' in the label when the selectedIndexChanged. Is this possible?
View 1 Repliesi have a formview1 in edit mode within a modal pop up extender and Update Panel
The update statement works but on the page is a gridview1 where I want
to display the new values.
I have added the below in page code but it still does not bind
the Gridview with new values when after I click UpdateButton in Formview - Only when I refresh the page.
protected void FormView2_ItemUpdated(object sender, FormViewUpdatedEventArgs e)
{
GridView3.DataBind();
ObjectDataSource50.DataBind();
}
My DataTable is programatically generated, and contains objects of type JobInstance in the cells.
[Code]....
When I bind this DataTable to an ASP GridView, it only displays the first column. But if I remove the "typeof(Job)" when creating the column (the line with // !!!), the GridView displays all the columns by showing the result of JobInstance.ToString() in the cells. However, I have no access to the underlying JobInstance object, only the string values that are being displayed.
I need access to the JobInstance object when displaying the GridView (for example in the OnRowDataBound), because I want to access the fields inside JobInstance for each cell to determine formatting options, and add other links in each cell.
i'm using asp.net MVC 2.0 , now i want to use a grid view in my applicationbut i don't want to use the third party control. my data contained in a datatable. so i want to bind this datatable with the gridview.
View 6 RepliesI had a problem in binding the checkbox list. Here I explain I had a database with 3 columns.
ex:
address name number
bangalore seker 987585
mangalore shankar 658741
bangalore kanna 589725
Now I have select the bangalore in address,so i may get seker and kanna.
And now i have display in my page as like this to checkbox.
seker
987585 same kanna sholud be displayed.
that is, the seker should be in label and the number should be in checkbox.
Which one is faster? For a dropdownlist binding it the first time and using ViewSate or Turning of viewstate, keeping the data in a static datatable and binding the dropdownlist each time on a postback
View 7 RepliesI will get required data from the web method that returns as table!!!
[System.Web.Services.WebMethod]
public static DataTable call(String code)
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
[Code] .....
on which all conditions we use dataset and datatable to bind data to a gridview?
View 2 RepliesI have a Gridview and two link button in that GridView , one link button click is to add edit row ( Edit ), one link button click is to select row ( Select ). I have a dropdownlist inside row which selected when i click link button Select in the gridview edit template, as of my business logic i need to show the dropdownlist only when the user clicks Edit button and when the user clicks Select button . That mean when the user clicks Select button then they clicks Edit button on the gridvview i should allow him to edit the dropdownlist (showing the value to the user through a label).
ASPX CODE
[Code].... C#
When I click Select link button , then I click Edit link button . They have errors : Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I don't know what error?. How to fix it
I have a delimted file , like a csv file but the delimters are # and not ,
I assume I would use SqlConnection and SqlDataAdapter
So for a csv file what is the sequence to read in for example c:datademo.csv
What would the connection string be.
Also can you specifiy a different delimiter.
The code below is what I assume it would possibly look likea although its only a frst guess.
[Code]....
i have 2 dropdown list and i need to create a Generic method so that I an reuse it...
View 1 RepliesGridview binding data from database without doing postback on the select of item in dropdown.i know it is possible through ajax update panel but for some specific reason it can't use it.And i think that gridview is a server-side control and if i implement it by using table structure , jquery ajax and web service then it will loose all gridview properties of edit, update and paging etc.
View 1 Replies i am using ajaxtoolkit:combobox and i tried to bind data to this control in code behind file.but it is taking 3 to 4 mints to bind data and display the page. I am providing my aspx code and code behind code here
[Code]....
Code behind code:
[Code]....
GetPrograms() method will return almost 6000 records. to load the control it is taking almost 4 minuts..
I am developing a asp database that is linked with SQL Database. When I am tryind to Find Control (GridView2) inside of another control (Panel2) that sits in Item Template for DetailsView, I got an error message:
Object reference not set to an instance of an object.
<asp:DetailsView ID="DetailsView1" HeaderText="Details" HeaderStyle-CssClass="labelheadRight" runat="server" AutoGenerateRows="False" DataKeyNames="pk_BackupDriveSerial"
DataSourceID="SqlDataSource1" GridLines="None"
CssClass="Detailsview" AllowPaging="True"
OnDataBinding="DetailsView1_OnDataBind"
OnItemInserted="DetailsView1_OnInsert"
OnItemDeleted="DetailsView1_OnDelete"
>
<Fields>
<asp:BoundField DataField="pk_BackupDriveSerial" ControlStyle-CssClass="dropdownsize"
HeaderText="Serial No" ReadOnly="True"
SortExpression="pk_BackupDriveSerial" >
<ControlStyle CssClass="dropdownsize"></ControlStyle>
</asp:BoundField>
<asp:BoundField DataField="BackupDriveMake" HeaderText="Make" ControlStyle-CssClass="dropdownsize"
SortExpression="BackupDriveMake" >
<ControlStyle CssClass="dropdownsize"></ControlStyle>
</asp:BoundField>
<asp:BoundField DataField="BackupDriveModel" HeaderText="Model" ControlStyle-CssClass="dropdownsize"
SortExpression="BackupDriveModel" >
<ControlStyle CssClass="dropdownsize"></ControlStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Type" SortExpression="fkid_BackupDriveTypes" ControlStyle-CssClass="dropdownsize"
Visible="False">
<EditItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%# Bind("BackupDriveMake") %>' Width="145px"></asp:Label>
<br />
<asp:TextBox CssClass="dropdownsize" AutoPostBack="true" ID="DropDownList5" runat="server" Text='<%# Bind("BackupDriveModel") %>' ></asp:TextBox>
<br />
<asp:Panel ID="Panel2" runat="server" CssClass="dropdownpanel" >
<asp:GridView CssClass="dropdowngrid" ID="GridView2" runat="server" AutoGenerateColumns="False"
CellPadding="4" DataKeyNames="pkid_BackupDriveTypes" SelectedValue='<%# Bind("fkid_BackupDriveTypes") %>'
DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="GridView2_OnChange">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField DataField="pkid_BackupDriveTypes"
HeaderText="pkid_BackupDriveTypes" InsertVisible="False" ReadOnly="True"
SortExpression="pkid_BackupDriveTypes" Visible="False" />
<asp:BoundField DataField="BackupDriveMake" HeaderText="Make"
SortExpression="Make" />
<asp:BoundField DataField="BackupDriveModel" HeaderText="Model"
SortExpression="Model" />
<asp:CommandField ShowSelectButton="True" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</asp:Panel>
<asp:DropDownExtender ID="DropDownExtender2" runat="server" DropDownControlID="Panel2" TargetControlID="DropDownList5">
</asp:DropDownExtender>
</EditItemTemplate>
[Code]....
I also tried
[Code]....
I had a little project is create dynamic control. My project had get detail of content and replace in sign string, Add control in sign. After click button I will find in control, I had added on page load in panel. I can't get value in child control panel, Don't have control in panel. My source is
protected void Page_Load(object sender, EventArgs e)
{
string config_design = GetConfigueKey(configDesign);
Genform(config_design, GetContent(config_design));
if (IsPostBack)
{
btn_submit_click(sender, e);
}
else
{
string config_design = GetConfigueKey(configDesign);
Genform(config_design, GetContent(config_design));
}
}
protected String GetContent(string designname)
{
string rev = "";
mClsDB = new clsConn();
strSql = "SELECT STR_DESIGN_CONTENT,STR_DESIGN_NAME,INT_FORM_ID FROM TBL_DESIGN WHERE INT_DESIGN_ID = " + designname + " ";
DataTable dt = mClsDB.GetDataTable(strSql);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
rev = dt.Rows[0]["STR_DESIGN_CONTENT"].ToString();
}
}
return rev;
}
protected void Genform(string designname, string content)
{
string rev = content;
mClsDB = new clsConn();
//strSQL = " SELECT INT_FIELD_ID,STR_FIELD_NAME,STR_FIELD_SIZE,STR_FIELD_CSS,STR_FIELD_DEFAULTVALUE,BIT_FIELD_VISIBLE,INT_FIELD_VALIDATE_TYPE,STR_FIELD_MINMAX,STR_FIELD_TYPE_NAME ";..................
I am using ASP.NET and Sharepoint and I'm getting a list of documents and displaying them in an SPGridView (sharepoint grid view)
How I seem to be only able to add data as a string to my DataTable.
See the line :
row["Title"] =
"<a href="" + itemUrl +
"">" + item["Title"] +
"</a>";
Is there anyway I can add a control here (say for example a HyperLink)
DataTable myDataProvider = GetDatatable();
view = new
DataView(myDataProvider);
//grid is of type SPGridView (sharepoint grid view)
[Code]....