|
|
please send me the code to get values from the database(SQL Server 2000) to a dropdown list in ASP.Net.
-- modified at 3:14 Friday 24th August, 2007
|
|
|
|
|
Which database?
Which language?
Use an OleDbConnection and a command object to perform a sql query and then as you loop through your results populate the list. You can find documentation on this in the MSDN.
|
|
|
|
|
try the following code:
C#:
-----
SqlConnection con = new SqlConnection(connectionString);
String sql = "SELECT <field name=""> FROM ";
SqlCommand cmd =new SqlCommand(sql,con);
SqlDataAdapter sda =new SqlDataAdapter(cmd);
DataTable dt =new DataTable();
con.Open();
sda.Fill(dt);
DropDownList1.DataSource =dt;
DropDownList1.DataBind();
|
|
|
|
|
SqlConnection con= new SqlConnection("Server=IBM;DataSource=Master;User Id=sa;Pwd=sa");
SqlDataAdapter ada=new SqlDataAdapter("select * from customer",con);
DataSet ds=new DataSet();
ada.Fill(ds);
DropDownList1.DataSource=ds1.Tables[0];
DropDownList1.DataTextField=ds1.Tables[0].Columns[1].ToString();
DropDownList1.DataValueField=ds1.Tables[0].Columns[1].ToString();
DropDownList1.DataBind();
VanithaVasu
|
|
|
|
|
First create Connection with database and then
Dim databaseRecord As SqlDataAdapter
Dim dstRecord As DataSet
databaseRecord = New SqlDataAdapter("Select * from ", con)
dstRecords = New DataSet
databaseRecord .Fill(dstRecords)
dropdownlistname.DataSource = dstRecords
dropdownlistname.DataTextField = "<table_column_name>"
dropdownlistname.DataValueField = "<table_column_name>"
dropdownlistname.DataBind()
ash83
|
|
|
|
|
First create Connection with database and then
Dim databaseRecord As SqlDataAdapter
Dim dstRecord As DataSet
databaseRecord = New SqlDataAdapter("Select * from ", con)
dstRecords = New DataSet
databaseRecord .Fill(dstRecords)
dropdownlistname.DataSource = dstRecords
dropdownlistname.DataTextField = "<table_column_name>"
dropdownlistname.DataValueField = "<table_column_name>"
dropdownlistname.DataBind()
I hope this will workout
ash83
|
|
|
|
|
|
The Calendar Control has a property called SelectedDate. When you post back your first page, store that value from Calendar1 into a session variable. On your second page, you set Calendar2's SelectedDate to the session variable that has the original date.
|
|
|
|
|
Hello Everyone,
Can anybody let me know how set the width of a text box and other controls so that they look similar as they look in Internet Explorer
Actually i set a textbox width : 250 px; and it's being displayed great in Internet Explorer but in Mozilla it's looking just simple and even there is no effect in textbox's width..............................
|
|
|
|
|
Why don't u use CSS.
ash83
|
|
|
|
|
Actually i'm not much familiar to it can u suggest me how to use css
plzzzzzzzzzzzzzzzzzzzzzzzzzzz......
|
|
|
|
|
You should know. After all, you are THE KNOWLEDGE, no? 
Search online for CSS stylesheets, you will find plenty of examples 
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
try to use properties which are supported by both IE & mozilla
|
|
|
|
|
Hi to all.
I have problem here. I need to get array of directories contained in the directory where my default.aspx is. If I write so:
<br />
DirectoryInfo dir1 = new DirectoryInfo(@".");<br />
I'm getting the "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE" directory.
My question is: how can I get the DirectoryInfo of the directory where my default.aspx file is, not pointing to DirectoryInfo constructor the whole path?
|
|
|
|
|
string[] dirs = Directory.GetDirectories(Server.Mappath(""));
Please let me know if it helps.
|
|
|
|
|
Should I include some additional namespace?
|
|
|
|
|
Thank you a lot. It really helped. 
|
|
|
|
|
Can anyone teach me how to scroll news or data which is present in SQL Server Database on the web page using asp.net
Thanks in advance.
|
|
|
|
|
Well, the first thing to do is decide on a method to retrieve the data from the database. I would recommend stored procedure for that. Then you should create a data access layer to encapsulate the calls to the stored procedures. Once your retrieve the data, you can show it using a GridView control, a repeater or a DataList depending on your requirements. In a general view, that's all I can think of right now. Check for articles here on codeproject, I'm sure you will find some examples. If not, you will surely find something online. If you have more specific questions, you can post them here to discuss them.
Talal
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
gampalabhargav wrote: how to scroll news or data
Do you mean How to display moving/scrolling text in a web page?
Regards
John
|
|
|
|
|
gampalabhargav wrote: on the web page using asp.net
ASP.NET can't do anything in scrolling. You can use some javascript or HTML marque to do scrolling. Get details from database and format it with the javascript you are using for scrolling. Set the string to a literal control. You are done.
|
|
|
|
|
|
what wil be the correspomding vb.net code for this:-
if(!Convert.IsDBNull(TxtBxMp .Value)
{
cmd.Parameters("@no_mp_record").Value = CType(TxtBxMp.Text, Int32);
}
|
|
|
|
|
Well, this is not valid code. It's missing a ), and CType is already nasty VB code, C# does not support it ( I just double checked ).
Replace the ! with Not, replace the {} with then and endif, remove the semicolon, and you're probably there.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
