How to pass parameters to a stored procedure while using gridview - ASP.NET Discussion Boards

Re: Memebership.ResetPassword() Problem

janet20088-Jan-08 18:25

janet2008

8-Jan-08 18:25

May be u tried to insert data to database more than the field width.

customize the datatable

Basheer8-Jan-08 17:19

Basheer

8-Jan-08 17:19

how to customize the datatable from database?

Re: customize the datatable

Christian Graus8-Jan-08 18:44

Christian Graus

8-Jan-08 18:44

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 )

Re: customize the datatable

ctlqt128-Jan-08 21:48

ctlqt12

8-Jan-08 21:48

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 ^^

auto email generation

chandra_778-Jan-08 11:48

chandra_77

8-Jan-08 11:48

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

Re: auto email generation

Christian Graus8-Jan-08 13:55

Christian Graus

8-Jan-08 13:55

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 ?

Re: auto email generation

ctlqt128-Jan-08 21:54

ctlqt12

8-Jan-08 21:54

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 ^^

How to pass parameters to a stored procedure while using gridview

asrs638-Jan-08 8:31

asrs63

8-Jan-08 8:31

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.

Re: How to pass parameters to a stored procedure while using gridview

DotNetXenon8-Jan-08 10:02

DotNetXenon

8-Jan-08 10:02

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

Re: How to pass parameters to a stored procedure while using gridview

asrs638-Jan-08 10:57

asrs63

8-Jan-08 10:57

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.

Get whole id of control

Chazzysb8-Jan-08 5:37

Chazzysb

8-Jan-08 5:37

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

Re: Get whole id of control

Not Active8-Jan-08 5:51

Not Active

8-Jan-08 5:51

Have you tried Control.UniqueId ?

only two letters away from being an asset

Re: Get whole id of control

Chazzysb8-Jan-08 6:11

Chazzysb

8-Jan-08 6:11

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

Re: Get whole id of control

Declan Bright8-Jan-08 8:54

Declan Bright

8-Jan-08 8:54

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 Smile | :)

Declan Bright
www.declanbright.com

Re: Get whole id of control

Christian Graus8-Jan-08 9:23

Christian Graus

8-Jan-08 9:23

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 ?

Paper size using CSS[Stylesheet]

manowj8-Jan-08 4:45

manowj

8-Jan-08 4:45

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

Hate this dialog - Help Update In Progress

CooperWu8-Jan-08 4:43

CooperWu

8-Jan-08 4:43

Always display this dialog when I wanna find something on VS2005/8 document... Dead | X|

<br />
Help Update In Progress<br />
Help is updating to reflect your recent changes. This may take several minutes.

Re: Hate this dialog - Help Update In Progress

Anders Øyvind Sætre15-May-09 0:26

Anders Øyvind Sætre

15-May-09 0:26

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!

can we use JavaApplets adn Servletts in Asp.Net???

chanzeb8-Jan-08 4:03

chanzeb

8-Jan-08 4:03

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.

Re: can we use JavaApplets adn Servletts in Asp.Net???

Christian Graus8-Jan-08 9:16

Christian Graus

8-Jan-08 9:16

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.

Sate Managment [modified]

Scotty868-Jan-08 2:35

Scotty86

8-Jan-08 2:35

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

Re: Sate Managment

Scotty869-Jan-08 5:34

Scotty86

9-Jan-08 5:34

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

New To asp.net ....Simple question

sindhutiwari8-Jan-08 2:15

sindhutiwari

8-Jan-08 2:15

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

Re: New To asp.net ....Simple question

Vasudevan Deepak Kumar8-Jan-08 2:21

Vasudevan Deepak Kumar

8-Jan-08 2:21

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

Re: New To asp.net ....Simple question

sindhutiwari8-Jan-08 2:27

sindhutiwari

8-Jan-08 2:27

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

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