|
sql query to get a fixed length or number of charater
|
|
|
|
|
|
I rerieve the data from databse and displayed the image in formview,the image detail in table control.But i want to display the image in table control and increase the particular column width and height
|
|
|
|
|
Well, resizing one columns width resizes them all, and it has nothing to do with your database. Are you displaying an image, or text ? Do you have the image data in your DB or just an image path ?
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 )
|
|
|
|
|
please tell me either code or little bit help
about grid view style.
I want to show data in grid view with attractive looking by
writing code explicitely.
I need this one for going on live project in my company.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
use CSS styles... background color, font, border..
|
|
|
|
|
How Memebership.ResetPassword() Works in c#.Give me some code to solve the pbm.I code it but an exception of string or binary truncted occurs in sql database aspnet_membership table.What is the problem.Please help me by sending code.
|
|
|
|
|
May be u tried to insert data to database more than the field width.
|
|
|
|
|
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!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
