|
I'm booked until later next week. If that works for you, let me know.
|
|
|
|
|
hi all,,
plz let me know the query to populate a dropdownlist with the database names available in sqlserver....!
|
|
|
|
|
SqlConnection myConnection = new SqlConnection(connectionString);<br />
SqlDataAdapter myCommand = new SqlDataAdapter("select FirstName, LastName from NameList", myConnection);<br />
<br />
SqlDataReader dr;<br />
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);<br />
while (dr.Read()) {<br />
myDropDownList.Items.Add(new ListItem((String)dr["FirstName"]+dr["LastName"],"")); <br />
}<br />
dr.Close();<br />
Regards,
Satips.
|
|
|
|
|
hello satips....u ahven't understand my questions
my requirement, i want to populate a dropdownlist with all the database names .....like master,nothwind,.....(my own databses)....etc
i don't want to select some columns from some table
plz help me....!
|
|
|
|
|
Sorry for the Mistake.
Try how Chetan has stated i hope that will work.
Regards,
Satips.
|
|
|
|
|
Hi,
You can do this by connecting to the "master" database of the particular SQLServer and querying "sysdatabases" table.
The following is the code sample.
SqlConnection conn = new SqlConnection("Data Source=servername;Initial Catalog=master;User ID=uid;Password=pwd");
SqlCommand cmd = new SqlCommand("select dbid, name from sysdatabases");
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DropDownList1.DataSource = dr;
DropDownList1.DataTextField = "name";
DropDownList1.DataValueField = "dbid";
DropDownList1.DataBind();
dr.Close();
I hope this will solve your issue.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
thanqs chetan...this stuff worked for my requirement
|
|
|
|
|
hello chetan....plz let me know the sql query for retrieving the user tables present in the selected database
thanqs in advance..![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi,
To get all the user tables for the selected database, u have to connect to that database and query its "sysobjects" table.
"select name, id from SysObjects where Type = 'U'"
This way you can get names of all the user tables of the selected database.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
hai every one
please give one sample coding about pop-up calander asp.net 2.0 using c#.net
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
|
thanks
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
Welcome.
Regards,
Satips.
|
|
|
|
|
Hi,
Could someone help with this. I have a table of users (Name, old ID, New ID, Email Address)
I want to send a communication to all users about thier new id information. The system should
only pick thier information only from the table. How can i do this using asp
Your responses would be appreciate. Thanks
Cheers
Selvan
Selvan
|
|
|
|
|
Have you heard about the SMTP.
SMTP.[^]
Regards,
Satips.
|
|
|
|
|
Hi Satips,
Thanks for your reply.
Yes, i am aware of smtp.
I used CDONTS to send emails to particular users based on the name input.
Now, i want to send out emails based on a table to users and send only thier
information automatically
Cheers
Selvan
|
|
|
|
|
Hi all,
I have two images in ItemTemplate one is sad.gif the other is laughing.gif. In EditItemTemplate I have a RadiobuttonList that Has two RadioButtons one is Good Mood and Bad Mood. The way it works When one selects the Bad Mood RadioButton Image sad.gif is selected and if Good Mood RadioBuuton laughing.gif is selected. and this is how I'm coding it:
<asp:Image id=Image1 runat="server" ImageUrl='<%# DataBinder.Eval(Container.DataItem,"MoodToday")=="Bad Mood" ?"sad":"laughing" +".gif"%>' ImageAlign="Middle" Visible="False"></asp:Image>
The Problem is whether Bad Mood or Good Mood is selected only image.gif appears can some one help me out please?
Thanks
|
|
|
|
|
Don't Repost. [^]
Guffa has answered there ther may be a problem with Eval did you correct that one.
Regards,
Satips.
|
|
|
|
|
i want to get the total time for the session for my site and also want to get the computer name of the client connecting with my server using asp.net in visual studio2005
Kindly send the requested answer to atifmeer50@hotmail.com
|
|
|
|
|
I have a grid view and want to sort the Gridview when I click on columns.
Could you please email me the code.
Regards,
hahii
|
|
|
|
|
Why don't you tell us what you have tried so far and we can help. Don't just ask for code.
only two letters away from being an asset
|
|
|
|
|
I have a CustomValidator control in an app and for some reason it seems to ignore the CssClass property. I've tried setting this in design-mode as well as programmaticaly at runtime and it still appears without the styling. I have at least one RequiredFieldValidator that has its CssClass set to the same value and it does recognize the styling.
Has anyone else had a problem with this and/or found a workaround?
|
|
|
|
|
I believe the "CssClass" property gets change to a "class" attribute in the generated HTML code. Thus, "CssClass='someclass'" changes to "class='someclass'". Also, you will need to have a stylesheet or (embedded stylesheet) that assigns some style such as ".someclass { color: gold; }".
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
If you re-read my original question I mentioned that "I have at least one RequiredFieldValidator that has its CssClass set to the same value and it does recognize the styling.".
I do have a stylesheet reference with a valid class, and as I said, other validation controls do recognize the CssClass, however, the CustomValidator does not. It seems that someone else must have experiences this.
|
|
|
|
|
Since you weren't very specific about the value of the CssClass, I wanted to make sure you were using an appropriate value. However, I am sorry that I misread your last statement.
Nevertheless, the value you gave the CssClass property must be associated with a style whether it is embedded or external. Your problem is with CSS. A possible problem could be that your "class" style is being overruled by a more local "style". For instance, if your CustomValidator sets its style attribute to "color: red;" and your class style sets its style to "color: green;", the browser will only display red text. Also, since the validators become span elements in HTML, you can only apply styles that affect inline elements unless you apply a "display: block;" style.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
