[WebMethod]
public String AuthenticateUser(String username, String password)
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
[code]...
Also how will i write the code on the page where i am reading the returned value from this webservice?
I have a products table with 3 fields name, price and quantity, I need to fill a datatable with those 3 fields and using a foreach build a chain. I build my chain currently using a datagrid with my following code
this code work good.
string item_name;
string amount;
string quantity;
[Code]....
but I like to form my chain directly from datatable, not rely on a datagrid.
I'm having a problem with reading a string from sqlserver database and use it as the text of a label,
getDescTableAdapter gd = new
getDescTableAdapter();
Label2.Text = Convert.ToString(gd.GetDesc(pid));
what i get in the form is: getDesc ! everything is right in the dataset and if i bind it to a gridview it works fine but when i convert it to string it seems it converts the table adaptor's name instead of the value.ance
this is the web method I'm using to convert my DataTable into JSON string:
[Code]....
But I'm not sure this is as good and as fast as it should be. I am sending to client side a JSON string format, but I think maybe there is a better way of doing this. I know there is JSON.NET
but I didn't see there any converting for DataTables.
Can we convert the Repeater items back to a datasource?
At post back, I want to convert the repeater items into a datatable which is a datasource was given to the repeater.
I am doing GridView Sorting without ObjectDataSource. For this requirement I need to convert DataTable to DataView, I know I can do that in VS 2008 but How can I do this in VS 2005.
View 20 RepliesI have one gridview and i want to take all the values in a datatable or dataview.
I tried like this
DataTable gridTable = (DataTable) dataGrid1.DataSource;
but gridTable is showing null, it should not show null because gridview has lot of records with 3 columns
Is there any way i can convert/store a gridview.Datasource records in a datatable or dataview?
How to allow null value on my program?
for below statement, "WARNING_TYPE" IS NULL..
but when I run, it promp me error..what are the correct statement should i write. tq all
l_Connection.ConnectionString = constr
l_Command.Connection = l_Connection
l_Command.CommandType = CommandType.Text
l_Command.CommandText = " SELECT UNP.EMPLOYEE_ID, UNP.UNPAID_DAYS, ABST.ABSENT_DAYS, WARN.WARNING_TYPE " +
[code].....
how would one go about converting a string to an SQL time data type? Lets say i wanted to convert @param1 to SQL time and @param2 to SQL date.
[Code]....
I know there are about a million posts on this topic, and I have attempeted to use many of them. However, I keep getting an error when I attempt a simple SQL update. Here is my code:
[Code]....
Here is my error:
[Code]....
I am trying to update a coulmn in datatable but keep getting error:
Input string was not in a correct format.Couldn't store < > in SortOrder Column. Expected type is Int32.
SortOrder is column of Type Integer that either contain Null or number.
[Code]....
I have a column in my gridview titled Progress. The data is currently consisting of integer values such as 1, 2, and 3. How can I change them to say "Good", "Review", and "Redo" based on their value?
View 4 RepliesI have a GridView where the user can choose an occasion, and I want to show the occasion date in a calendar. How should I convert the date string from the GridView? The code below works except for the rows concerning Date and calendar:
[Code]....
I've been successful in creating GridView controls programically using c#. I'd like to take advantage of using the clientmode=predicatable but I can't resolve setting the ClientIDRowSuffix value. Below is a code snippet:
public void GenerateView(int fileno, string GridType, GridView dataView)
{
object ctrl = FindControl("pnlForm");
System.Web.UI.WebControls.Panel ctrlPanel = (System.Web.UI.WebControls.Panel)ctrl;
dataView.Width = 640;
dataView.ForeColor = System.Drawing.Color.Black;
dataView.BackColor = System.Drawing.Color.Beige;
dataView.AutoGenerateColumns = false;
dataView.Caption = "<B> indicate your selection by typing Add of Delete in the Action box below</B>";
//Resulted in the following error
// Cannot implicitly convert type 'string' to 'string[]
// dataView.ClientIDRowSuffix = "CTR_SEQ";
// I also tried casting it
// CS0030: Cannot convert type 'string' to 'string[]'...........................................
I am having trouble converting a ienumerable to a datatabe here is the code:The problem is in the following line-
ViewState("dt") = elements.CopyToDataTable()
Dim dt As New DataTable
Private Sub DisplayAuthorLastName(ByVal strLetter As String)
[code]...
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="LabelSubUpdateID" runat="server" Text='<%# Eval("UpdateID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Get the Label value inside the Gridview ItemTemplate and convert to string C#?
I have store procedure which return result set. I have used LINQ datacontext object to get the result set from this store procedure, which returns the result set in IsingleResult format.I bind this IsingleResult to my gridview.
I want to convert this IsingleResult into DataTable format so I can sort the gridview.
how can i convert the column data in datatable to integer array the column data in datatable stored as:
1
2
3
4
after store to integer array,how can i get the max value in array
[Code]....
Forms Data Controls :: Failed to convert parameter value from a DataControlFieldCell to a String - GridView Error?
I am getting error "Cannot implicitly convert type 'string' to 'System.Data.DbType".
When I am passing Stored procedure parameter it expets 'System.Data.DbType" and the Data member is declared as a string.
How could I parse a Json string with all the data from my table to a DataTable or a DataView?
View 5 Repliesi have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
View 2 RepliesIf I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
View 1 Repliesim trying to copying specific record from one datatable to another datatable i used below code
public System.Data.DataTable selectspecificdatarow(System.Data.DataTable dtg, int count, int startindex)
{
System.Data.DataTable dtn = dtg.Clone();
for (int i =startindex; i < count; i++)
[Code]....
its taking too long time in cloneing is there any better way to do this task which is Time effecent
I need to limit the length of the string that load into a DataTable that is being used to display. The data I am loading is coming from another DataTable. How do I shorten row["CG_GalleryName"] contents to 24 characters.
Convert.ToString(row["CG_GalleryName"]) -- how do I set this length to 24 characters? Using it in the below code.
if (Convert.ToInt16(row["rnum"]) == 1)
{
dr = GLinks.NewRow();
dr["rnum"] = row["rnum"];
dr["L_URL"] = row["L_URL"];
dr["CG_GalleryName"] = row["CG_GalleryName"];
dr["L_Picture"] = row["L_Picture"];
GLinks.Rows.Add(dr);
