|
In my project i want to use crystal reports .but in crystal reports how to pass parameters(ie when user enters any no in textbox it
should display all deatails of that employe , and in dropdown list also the same )
|
|
|
|
|
|
hi everyone.
i am inserting values in the table
the code.
<br />
SqlCommand com=new SqlCommand();<br />
con.Open();<br />
com.CommandText="insert into tbl([Name],FName,Address) values('Angelina','Carlos','sedny')";<br />
com.Connection=con;<br />
com.ExecuteNonQuery();<br />
con.Close();<br />
This code is running perfectly no Exception occurs no Error.
it is also returning the rows effected. But after successful execution
the values are not inserting in the database.
and when i run the same query in QueryAnalyzer it is ok and inserting the values but from the Ado.Net it is not working.
i don't understand this problem.
can anyone help me in this regard?
thanks in advance.
|
|
|
|
|
Reconfirm if the connectionstring is perfect. I think it is inserting in some other database ...
If ADO.NET cannot insert in database, it will throw you an error. 
|
|
|
|
|
sir thank you for your reply
i have checked the connectionstring it is ok.
and i have no other database with same name and table, columns
only the select query work.
nor update and nor delete and nor insert work.
|
|
|
|
|
Try inserting the data inside the transaction and commit the transaction in .net code
modified on Wednesday, December 30, 2009 12:48 PM
|
|
|
|
|
Put a breakpoint in the con.Open() line and check the connection string property of connection object. Sometimes the connection string itself referring a wrong location.
As the other user said, ADO.NET will throw error if the execute fails. So, you must me referring a wrong database.
Zafar Ali Khan 1900 wrote: com.CommandText="insert into <DATABASENAME>.dbo.tbl([Name],FName,Address) values('Angelina','Carlos','sedny')";
replace the <DATABASENAME> with your database name (Full qualifier name). This would help if two or more databases has table in same name and your connection string does not have any Initial Catalog mentioned (default is master database).
Better you post your connection string also
|
|
|
|
|
Hello,
I have a CITRIX client application. usually I invoke it by clicking the shortcut in the desktop. Now, I would like to invoke this application from a web page (from my mail box). How can I accomplish this. Any help would be appreciated.
Thanks for your time
Sebastian
|
|
|
|
|
Check my answer over
here[^]
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
|
Let me know if you have any issue
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hi All,
Please give me idea..
How to call the webservice through WSDL file in ASP.Net
Actually i have WSDL file..Please give me any sample applications
Regards
Somasundaram
I want to join in the website
|
|
|
|
|
somagunasekaran wrote: How to call the webservice through WSDL file in ASP.Net
I didnt get your point.
You need to consume web services only. If you are using Visuals studio, Go to your web Application > Right Click > Add Web Reference > Give the web service url
Then you need to create the object to call methods !
Let me know if you have further issue 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
hai,
currently i m using asp.net 2.0 (C#)
i m trying to open a new popup window (or window) so as to display the project developer name and his information. But this has to be popup'ed only when user press some key combinations (say.. ctrl+d). i tried this by assigning accesskey to a button and redirected. but while i hide that button the shortcut does'nt work..
is there any other way to achieve it?
help me.... - Karan
|
|
|
|
|
Hi
How do you hide the button?
if you set Visible to false the button's does not be inserted into page
you should hide the button using javascript code and css property.
Mohammad Khansari
|
|
|
|
|
how to do this?
i found we can hide the button using
document.getElementById('Button1').style.visibility='hidden'; but i need to use this in page load in ASCX page. how to use it.
|
|
|
|
|
It's better to use display stead of visibility
insert following code in Page_Load
hide the button
this.Button1.Style.Add("display", "none");
show the button
this.Button1.Style.Add("display", "inline");
hope to be useful for you
Mohammad Khansari
|
|
|
|
|
i have to get left position of the panel on pageload. i do get dat by playing a trick, but wt problem now i face is im not able to put dat value in the hidden control. below is code that i use for the purpose:
string strJS = @" <script language='javascript' type='text/javascript'> intWidth = document.body.clientWidth;intHeight = document.body.clientHeight;intWidth = (intWidth* 15/100);document.getElementById('<% =HpnlCtrlLeftPos.ClientID %>').value=intWidth; alert('Width : '+ intWidth +' Height : ' + intHeight); </script>";
Page.ClientScript.RegisterStartupScript(this.GetType(), "ScreenPosition", strJS);
it throws exception
can any body help me............
|
|
|
|
|
The exception thrown might help to solve the problem...
|
|
|
|
|
S_Aijaz1 wrote: string strJS = @" intWidth = document.body.clientWidth;intHeight = document.body.clientHeight;intWidth = (intWidth* 15/100);document.getElementById('<% =HpnlCtrlLeftPos.ClientID %>').value=intWidth; alert('Width : '+ intWidth +' Height : ' + intHeight); ";
Page.ClientScript.RegisterStartupScript(this.GetType(), "ScreenPosition", strJS);
Try this,
string strJS = @" intWidth = document.body.clientWidth;intHeight = document.body.clientHeight;intWidth = (intWidth* 15/100);document.getElementById('<% =HpnlCtrlLeftPos.ClientID %>').value=intWidth; alert('Width : '+ intWidth +' Height : ' + intHeight); ";
Page.ClientScript.RegisterStartupScript(this.GetType(), "ScreenPosition", strJS, true);
if this doesn't help, post the error message you getting.
|
|
|
|
|
thank you sir, i have have tried dis as well but it is not working, at page load it does nt find the hidden control
|
|
|
|
|
I am working on a web application and newly entered in the developement field.
I need your help in the completion of this application.I want complete code behind the
login page means what will be classes we will have to declare,Integration with master page,
Navigation and creating,access to db.
Thanks
|
|
|
|
|
Did you searched on google, you'll find many examples if you spend just 5 minutes for searching it.
|
|
|
|
|
one of my site is running online.I want to configure my online sql server database for application services.I know to do it locally but dont know how to do online.i did following steps:
>i selected configure sql server for application services.
>give database name and selected sql server authentication mode,give username and password
>but it does not show the list of database n shows error:
"failed to query list of database name from sqlserver.login failed for user.
the user is not associated with trusted sql server connection."
Tell me what to do n where m i wrong....thank's
|
|
|
|
|
I think this is the permission issue. Does your server is installed in a Mixed mode.. I mean can you connect with the same user from the Management Console ?
Check this :
http://support.microsoft.com/kb/889615
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
