|
how to customize the datatable from database?
|
|
|
|
|
The best way to change the data that comes out of hte database, is in the database. How do you want to change it ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Basheer,
If you want to customize datatable, you can get table by following code :
ds.Tables[0] //ds is dataset
When you get table in dataset, you can do anything with that table
Hoping this will help you ^^
|
|
|
|
|
hi
can anyone help me in generating auto emails after checking the credentials of the user.i am using .net2.0/vb.net/oracle
thank you
|
|
|
|
|
Please don't cross post.
Sending emails via VB.NET is very easy and widely documented. What do you want the auto emails to say, and what credentials are you talking about ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi chandra_77,
For sending mail in ASP.Net 2.0 ( C# ), you can use the following code
using System.Web.Mail;<br />
<br />
MailMessage mail = new MailMessage();<br />
mail.To = "<receiver's mail=";<br mode=" hold=" /">mail.From = "sender's mail";<br />
mail.Subject = "<subject>";<br />
mail.Body = "<mail's content="">";<br />
SmtpMail.SmtpServer = "<your mail="" server="">";<br />
SmtpMail.Send(mail); </your></mail's></subject></receiver's>
Hoping this will help you ^^
|
|
|
|
|
Hi,
I have created a small project which uses a SQL Server DB. I have a stored procedure whcih takes certain parameters.
In my website project I SQLDataSource defined which uses uses the stored procedure.
If I do not specify any of the parameters int he SelectQuery of the datasource the program hits the DB (can see in the SQL profiler) and gets the data, while if I specify the parameters and the program doesn't hit the DB (There is no entry in the SQL profiler). I just can't understand why it is happening as it doesn't give any errors.
Thanks for your time and help in advance.
|
|
|
|
|
Am posting a sample method which calls the GetSP() stored proc and passes a parameter named ID. Check if this is helpful.
public static DataTable GetAll()
{
connection.Open();
using (SqlCommand command = new SqlCommand("GetSP", connection))
{
command.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
SqlParameter idParameter = new SqlParameter();
idParameter.ParameterName = "@ID";
idParameter.Direction = ParameterDirection.Input;
idParameter.SqlDbType = SqlDbType.Int;
idParameter.Size = 4;
idParameter.Value = ID;
command.Parameters.Add(idParameter);
DataSet ds = new DataSet();
adapter.Fill(ds, "Delegate");
return ds.Tables[0];
}
}
}
------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates
|
|
|
|
|
Thanks for the reply, but I want to be able to do it through the SQLDatasource that I have defined. For this approach I will have to use SqlDataAdapter but I want to keep this as the last option.
|
|
|
|
|
Hi,
I have a user control with a number of controls on it including hidden fields.
lets say one of the hidden fields id is text1.
lets say the user control is added to an aspx page and the controls id is control1.
so at runtime the id of text1 becomes control1_text1_ctl00
I need to pass the id of the field to a javascript function how can i get the runtime id at runtime?
- if i say field.ClientID in the control code i get text1_ctl00
- if i sat field.Parent.ClientID i get text1
how can i get the full name of the field or the id of the control on the page?
Many thanks,
Chas
|
|
|
|
|
Have you tried Control.UniqueId ?
only two letters away from being an asset
|
|
|
|
|
Hi yes ive tried that - that gives similar results but for the name instead of the id with a $ instead of an _ so the value returned is text1$ctl00
|
|
|
|
|
Strange, I used ClientId for the same purpose the other day and it worked fine.
I'll give more detail of what I did as it may help you solve your problem.
I have 2 nested user controls and on the inner control I have a hidden input field with runat server:
<input id="text1" runat="server" type="hidden" />
At runtime the id is: userControl1_userControl2_text1
I use this.text1.ClientID when writing out a script block using ScriptManager.RegisterClientScriptBlock and it writes out userControl1_userControl2_text1 correctly.
Hope this is of some help 
|
|
|
|
|
I have done a LOT of this in recent times, and ClientID has never once failed to work for me. There's something else going on in your code, are the controls dynamically generated, or are other controls dynamically generated/added to the page after you get the Id ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Everyone,
Is it possible to print an address in a envelope size of "9.5 * 4.125" using css or asp.net or javascript.
Can anyone help me in this regard.
Regards,
Manowj
|
|
|
|
|
Always display this dialog when I wanna find something on VS2005/8 document...
<br />
Help Update In Progress<br />
Help is updating to reflect your recent changes. This may take several minutes.
|
|
|
|
|
It's some of the worst... If this doesn't get a decent upgrade for vs2010 I'm gonna be shocked! The .NET Framework are getting so huge, the need for a scalable documentation system is crucial!
|
|
|
|
|
Hi All,
I am new in Asp.Net.I want to use JavaApplets and Servlets in Asp.Net.
can I use???.If yes, then guide me..
Thanks in Advance.
Regards,
chanzeb chaudhary.
|
|
|
|
|
If they run on the client side, you can embedd them in your HTML, it doesn't matter that it was created using ASP.NET. If they run on the server, then I suspect not, at least, not easily.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi all,
I am using asp with the Session state managment. The problem i am having is with IE7. instead of using a cookie like Firefox does, it puts the ID in the URL (http://"webaddress""sessionid"/default.aspx). if i set up IIS to use cookie only, the session state is forgot. At the moment the Session state mode is "InProc" and the Cookieless mode is "AutoDetect". Is there something i should be doing to make IE use cookies instead of the URL? (this website is on a intranet)
Thanks
Scott
modified on Tuesday, January 08, 2008 9:08:02 AM
|
|
|
|
|
I fixed this by using the IP address instead of the machine name and it worked, although a little strange. Any ideas why this is?
Scott
|
|
|
|
|
Hi,
I want to add some flash effects to my page and some gif animations also
as i am new to asp.net i dont have idea abt this ....
plz can any one tell me steps to implement this..
REgards
SIndhu TIwari
Always Innovative
|
|
|
|
|
sindhutiwari wrote: some flash effects to my page
You use a OBJECT tag to achieve this.
sindhutiwari wrote: some gif animations
You use a IMG tag for this.
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
|
|
|
|
|
thanks for ur reply sir.......what i need is spoon feeding which i hate the most...so if u can give me a brief abt this then it will be much helpful to me
REgards
SIndu TIwari
Always Innovative
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
