|
Hi Cuckoo...
Actually u r using wrong method...
If u r trying to get a particular value, use executescalar instead of ExecuteNonQuery.
int y =null;
y = convert to int32(scmd.ExecuteScalar());
This is for single value only...
if u want to fetch more than one value better to take ExecuteReader().
krishna veer singh
|
|
|
|
|
Hai ,
But its also not working what to do now
|
|
|
|
|
Actually i want to do certain code if the value is already present in the table so was using ExecuteNonQuery().
|
|
|
|
|
Hi ..
Check for string and int.
If you aretrying to fetch int value then this code will work.
Otherwise take string variable and assign your value...
krishna veer singh
|
|
|
|
|
string tst = ((LinkButton)e.Item.FindControl("Oops")).Text;
ds.Tables[0].Rows[0].ItemArray[0] = ((LinkButton)e.Item.FindControl("Oops")).Text;
In string tst a particular value is comming but the same value is not assigning in dataset.
why, i'm unable to understand..
plz help... ASAP..
krishna veer singh
|
|
|
|
|
I am creating a site which is in other language rather than English.So how shall i do it,plz give me some solution.Thank you.
coolsatty
|
|
|
|
|
You can google with this keyword "ASP.NET localization".. It will show you the way how to multi-languages website with ASP.NET..
|
|
|
|
|
I am having a dropdrownlist which is getting values from the database.
I want that every time the page is loaded the first item that should be viewed is Select .I tried to set it from property Item and from coding also but i cant get Select in the form
The coding is as follows
private void pop_shift(DropDownList ddl)
{
SqlDataAdapter da = new SqlDataAdapter("select shift_name from shift_add",con);
DataSet Obj_dse = new DataSet();
da.Fill(Obj_dse);
ddl.Items.Add("-Select-");
ddl.DataTextField=Obj_dse.Tables[0].Columns["shift_name"].ToString();
ddl.DataSource=Obj_dse;
ddl.DataBind();
}
|
|
|
|
|
Cuckoo wrote: private void pop_shift(DropDownList ddl)
{
SqlDataAdapter da = new SqlDataAdapter("select shift_name from shift_add",con);
DataSet Obj_dse = new DataSet();
da.Fill(Obj_dse);
ddl.Items.Add("-Select-");
ddl.DataTextField=Obj_dse.Tables[0].Columns["shift_name"].ToString();
ddl.DataSource=Obj_dse;
ddl.DataBind();
}
Small change in the function.
private void pop_shift(DropDownList ddl)
{
SqlDataAdapter da = new SqlDataAdapter("select shift_name from shift_add",con);
DataSet Obj_dse = new DataSet();
da.Fill(Obj_dse);
ddl.DataTextField=Obj_dse.Tables[0].Columns["shift_name"].ToString();
ddl.DataSource=Obj_dse;
ddl.DataBind();
ddl.Items.Insert(0, "-Select-");
}
modified on Saturday, January 19, 2008 2:44:19 AM
|
|
|
|
|
|
Try
ddl.Items.Insert(0, "-Select-");
instead of
ddl.Items.Add("-Select-");
if you want the "-Select-" item to be the first item.
|
|
|
|
|
Thank You very much its working,god bless you
|
|
|
|
|
|
Hi i have put a checkbox on the page & adding a style style="display:none;" to it as:
<asp:checkbox id="CheckBox1" style="display:none;" runat="server">
now generated html after running project is: <span style="display:none;"><input id="CheckBox1" type="checkbox" name="CheckBox1" /></span>
rather than
why ? same thing is for asp:RadioButton control. but it doesn't happen for ASP:Button control. what is the reason?
|
|
|
|
|
Dear Friends,
I am new Visual Stadio.net I have one application ov VB.net connect with SQL Server 2000xp by using Odbc. And i want to make another ASP.net webpage which need to connect with SQL Server 2000xp by using Odbc as well.
in VB.net i use OdbcDataAdapter, DataTable, DataRow...
but in ASP.net there are not DataTable and DataRow.
Are them used other way else ? Can i use DataTable and DataRow like VB.net ?
Help....pls
VB.Net
|
|
|
|
|
If possible, you should use the SqlClient connection instead of the Odbc connection.
Sovann wrote: but in ASP.net there are not DataTable and DataRow.
Yes, there is.
You have full access to the .NET framework in ASP.NET.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Sovann wrote: but in ASP.net there are not DataTable and DataRow
You are in a confusion. ASP.NET do have OdbcDataAdapter, DataTable, etc. Check whether you have referred System.Data to the Website reference.
Again add Import statment as,
Imports System.Data
Imports System.Data.Odbc
to the Codebehind file.
|
|
|
|
|
Is there any specific reason that you are going for ODBC ? If not as Guffa suggested, use SQLConnection class. It is made to connect to SQL Server database. ODBC adds an extra layer to the communication, and it will be slow.
|
|
|
|
|
I have a link on my asp webpage to open a .ppt file in a new window. The file opens fine in IE 6 and FireFox. In IE 7, it opens PowerPoint with a blank slide. But if I right click the link on my webpage and save locally I am able to view the contents of the powerpoint. What is going on? Is IE7 blocking the content?
|
|
|
|
|
|
Is it possible to use C++/CLI as the 'code behind' of an ASP.NET page? I've been googling and found many responses that such thing is possible, yet I haven't found any example so far.
Thanks in advance.
Stupidity is an International Association - Enrique Jardiel Poncela
|
|
|
|
|
Yes. This article[^] explains how to do it.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks a lot.
Stupidity is an International Association - Enrique Jardiel Poncela
|
|
|
|
|
i am making a registration form and want to use CreateUserWizard control from login controls.
But there are only limited fields and i want to use some additional fields also like , zip,hobbies,education,etc and is there any way to do so without using the concept of "profile".
for this purpose i want to use my own database .
I am new to ASP.NET and C# (Beginner level) so i request you to post the code .
I will be highly thankful to you!
Er.Amar Shukla
|
|
|
|
|
I would start by reading the documentation[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|