Odbc in asp.net - ASP.NET Discussion Boards

Cuckoo18-Jan-08 19:37

18-Jan-08 19:37

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();
}

Re: Drop downlist problem [modified]

Venkatesh Mookkan18-Jan-08 20:37

Venkatesh Mookkan

18-Jan-08 20:37

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-");
}

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

modified on Saturday, January 19, 2008 2:44:19 AM

Re: Drop downlist problem

Cuckoo18-Jan-08 20:42

Cuckoo

18-Jan-08 20:42

thank you let me try it

Re: Drop downlist problem

Venkatesh Mookkan18-Jan-08 20:48

Venkatesh Mookkan

18-Jan-08 20:48

Try

ddl.Items.Insert(0, "-Select-");

instead of

ddl.Items.Add("-Select-");

if you want the "-Select-" item to be the first item.

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

Thank You

Cuckoo18-Jan-08 20:50

Cuckoo

18-Jan-08 20:50

Thank You very much its working,god bless you

Re: Thank You

Venkatesh Mookkan19-Jan-08 5:19

Venkatesh Mookkan

19-Jan-08 5:19

Thank you...

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

style="display:none;"

I Never Look Behind18-Jan-08 19:25

I Never Look Behind

18-Jan-08 19:25

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?

Odbc in asp.net

Golden Jing18-Jan-08 15:39

Golden Jing

18-Jan-08 15:39

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

Re: Odbc in asp.net

Guffa18-Jan-08 19:13

Guffa

18-Jan-08 19:13

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.

Re: Odbc in asp.net

Venkatesh Mookkan18-Jan-08 19:22

Venkatesh Mookkan

18-Jan-08 19:22

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.

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

Re: Odbc in asp.net

N a v a n e e t h19-Jan-08 1:27

N a v a n e e t h

19-Jan-08 1:27

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

IIS 7.0 and .ppt

Civic0618-Jan-08 8:57

Civic06

18-Jan-08 8:57

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?

Re: IIS 7.0 and .ppt

Mike Ellison18-Jan-08 14:29

Mike Ellison

18-Jan-08 14:29

Is something like this[^] happening for you?

Using C++

Fernando A. Gomez F.18-Jan-08 7:29

Fernando A. Gomez F.

18-Jan-08 7:29

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

Re: Using C++

pmarfleet18-Jan-08 10:37

pmarfleet

18-Jan-08 10:37

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

Re: Using C++

Fernando A. Gomez F.18-Jan-08 10:46

Fernando A. Gomez F.

18-Jan-08 10:46

Thanks a lot. Smile | :)

Stupidity is an International Association - Enrique Jardiel Poncela

how to add additional fields in UserCreateWizard control in ASP.NET2.0

Member 473069918-Jan-08 6:40

Member 4730699

18-Jan-08 6:40

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

Re: how to add additional fields in UserCreateWizard control in ASP.NET2.0

pmarfleet18-Jan-08 10:35

pmarfleet

18-Jan-08 10:35

I would start by reading the documentation[^].

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Advantages of ASP.NET 3.5 over ASP.NET 2.0

intelgenius18-Jan-08 4:25

intelgenius

18-Jan-08 4:25

Can any body please let me know what are the advantages of ASP.NET 3.5 over ASP.NET 2.0 ?

Re: Advantages of ASP.NET 3.5 over ASP.NET 2.0

Vasudevan Deepak Kumar18-Jan-08 4:40

Vasudevan Deepak Kumar

18-Jan-08 4:40

Check this out

http://msdn2.microsoft.com/en-us/library/bb332048.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

how a dropdown list selection changed event is called throug javascript

jagan12318-Jan-08 2:27

jagan123

18-Jan-08 2:27

using document.getElementById(button.ClientID %>').click iam able to call button event of teh server button but how can we call dropdown list selection changed event using jaascript

Re: how a dropdown list selection changed event is called throug javascript

szukuro18-Jan-08 2:45

szukuro

18-Jan-08 2:45

Not too surprisingly document.getElementById('<%=dropdown.ClientID%>').onchange

Re: how a dropdown list selection changed event is called throug javascript

N a v a n e e t h18-Jan-08 2:50

N a v a n e e t h

18-Jan-08 2:50

If you have enabled AutoPostBack property for drop down list, check the onchange JS event for that control. Make a call from your JS like that.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Trouble consuming a Web Service from a C# Windows Forms App

Bill Prada18-Jan-08 2:26

Bill Prada

18-Jan-08 2:26

Hi,

I'm starting at at a new job and am having some trouble making some legacy code work. The project was auto-imported to VS 2008 from 2005. There is a Web Service that works just fine when invoked in a browser but when it is instantiated in a desktop application all methods and members are visible but the methods all have a value of null.

I'm sure I'm overlooking something obvious here so I'm asking if anyone can point me in the right direction.

Thanks,
Bill Prada

Null/Empty item in combobox.

jdstuart18-Jan-08 2:26

jdstuart

18-Jan-08 2:26

Good day.

First, I have to ask, to please excuse my English.

I have an aspx page with 5 comboboxes on it. The 2nd combobox's details is dependand on the 1st one's selectedValue and combobox 3,4 and 5 is dependand on combobox2's selectedValue. Auto-postback is enabled on both combobox 1 & 2.

Whenever I choose a value in combobox 1, the data in combobox 2 gets updated and the first item in combobox2 is automatically selected. The problem with this is that data in combobox 3, 4 & 5 is dependant om the selectedValue of combobox2 and also needs to be updated with the new selectedValue of combobox2, but it does not get updated when the selectedValue of combobox2 changes as a result of the change in combobox1.

The problem exists when a users choice is the value already selected in combobox2, then the data for comboboxes 3, 4 & 5 aren't populated correctly.

It doesn't help disabling of hiding comboboxes 3-5 and only enabling it when the selectedValue of combobox2 changes, because the user will still click on the same value already selected, and the event will not fire.
I also tried adding a "empty" value to the combobox and selecting it as default, but this will lead to a foreign key violation in the databse.

The question is...
Is there a way, that I can (without adding an empty entry in the database - bad practise) set the initial selected item to a blank entry, thereby forcing the user to change the selected index?
I'm currently using ASP.Net 2.0 and the back-end code is in C#. I can make use of Javascript, but the application I'm developing doesn't work all to well with AJAX.

Thanks in advance.
JD Stuart

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.