|
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
|
|
|
|
|
|
I have been searching for a way to solve a problem all morning and can't seem to find any useful results on Google - I'm sure there will be a short answer to this, but I can't seem to get the right search string! I would appreciate any pointers that people can give me.
I have created a custom control to allow tabbed browsing. The principle is that the developer can use a multiview and view controls to create their content, and my control will generate buttons to look like tabs. When tabs are clicked the corresponding view will be shown.
I would like my control to have a property detailing all of the tabs it will contain including data for the caption and the View it targets. So far, what I have is:
<br />
public struct ButtonTarget<br />
{<br />
public View targetView;<br />
public string buttonCaption;<br />
}<br />
<br />
private ButtonTarget[] m_Tabs;<br />
public ButtonTarget[] Tabs<br />
{<br />
get { return m_Tabs; }<br />
set { m_Tabs = value; }<br />
}<br />
The problem is that the properties window in design view does not allow me to easily edit this property, so I would like to create a property page to allow the developer to easily edit the value of the property at design time.
I am aware that the code achieve the same effect is very simple just by creating a new button for each view on the form and adding an event handler, but the reason for using a control is to be able to reduce the amount of code on each page, and to allow dynamic adding of tabs at runtime more easily.
Thanks,
Chris
|
|
|
|
|
first click a button, half page display then next click another button display the remaining page using asp.net
|
|
|
|
|
I'm not quite sure if this is a problem you are having or is something you are trying to do!!!
I'll assume the latter, place 2 Panel controls on a page with the Visible property set to false and add the relevant content to the 2 panels. In the OnClick of the button check if the first panel control is visible, if its not the set its visible property to true and so on....
|
|
|
|
|
You can also achieve this with partial classes because at the end only one page will render.
Usman Munier
Xavor Corporation Pakistan
|
|
|
|
|
Hi All,
I developed web application using asp.net 2.0 ,C#.
My application looks fine(Display wise) in IE6.0 With CSS,but I run same application in IE7,Opera the controls like combo box are not displays properly[not aligh properly and size is too small] because of CSS.
Need help !!
Thanks in advance.
parthiban
modified on Tuesday, January 08, 2008 6:33:29 AM
|
|
|
|
|
is there anyway we can see your webpages?
What exactly does 'not display properly' mean? i.e. not displayign at all, displaying left of where its meant to?
cheers
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
