|
To Insert into SQL database try following steps
1 - Include System.Data.SqlClient
2 - Intialize SQLConnection class
3 - Set connection string
4 - Create SQLCommand class. You type queries in this class object
5 - Call SQLCommand ExecuteNonQuery() method.
Go through some books that explains ADO.NET in detail before you start.
|
|
|
|
|
hi navaneeth
thx for ur reply. I had already written the code for sql connection and all.
I am able to connect to sql, after connecting to sql only I am trying to insert the data but the that error msg is being displayed.
plz let me know whether i had written the code correctly mentioned earlier??
and also plz send me some refernces if any for learning this....
Sailaja
|
|
|
|
|
potlakayala wrote: plz send me some refernces if any for learning this..
Check This[^]
|
|
|
|
|
Your SQL insert statement does not appear to be correct.
INSERT INTO table(fieldname1,fieldname2,etc) VALUES(value1,value2,etc)
WHERE fieldnameX = valueX;
|
|
|
|
|
I don't want to give any fixed value in the insert command. I want the command to take the user input values entered from the UI and store those values in the database.
Sailaja
|
|
|
|
|
Hi,
In my asp.net application, i am opening a child window.I want to disable the close button on the title bar. Does anyone knw how to go about in doing it.
Thanks,
Riz
Riz
|
|
|
|
|
You can't.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
private const int SC_CLOSE = 0xF060;
private const int MF_GRAYED = 0x1;
[DllImport("user32.dll")]
private static extern IntPtr GetSystemMenu(IntPtr hWnd, bool bRevert);
[DllImport("user32.dll")]
private static extern int EnableMenuItem(IntPtr hMenu, int wIDEnableItem, int wEnable);
private void Form1_Load(object sender, System.EventArgs e)
{
EnableMenuItem(GetSystemMenu(this.Handle, false), SC_CLOSE, MF_GRAYED);
}
Naresh Patel
|
|
|
|
|
 Read question clearly please. It is for ASP.NET not desktop application
|
|
|
|
|
code for interactivity of .net application with telephone responses
|
|
|
|
|
What does that mean? Are you asking a question or making a statement? Either which way, you need a verb in there somewhere.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
Hi All,
I need to Upload a Image. My web application is an Intranet site and it also sends mails to anyone (those not in network).
My problem is that when I send a mail with Images, Images are not shown to any different user other than those in network.
Please help me how do I do this.
Thanks in advance.
|
|
|
|
|
ASP.NET 2.0 wrote: Images are not shown to any different user other than those in network.
I assume you are referring images in the intranet server right ? User will be reading mail from his mail box, that is on remote server. So it won't get path to your local intranet server. If your intranet server having a static IP then try giving path with specifying that
|
|
|
|
|
Thanks for the reply.Is there other method as I cant use this.
|
|
|
|
|
Since your server which contains images is in local intranet, I think it is tough to implement. If it is on internet you can refer images.
|
|
|
|
|
Ya thats my problem, can u help me?
Thanks in advance.
|
|
|
|
|
ASP.NET 2.0 wrote: Ya thats my problem, can u help me?
As I told earlier, I don't find any solution for this. I will suggest you something, but don't know whether it is appropriate.
1 - When sending mail try attaching the images tooo. This won't work for images that you set as background.
2 - Upload images to an online server which is accessible through internet. In your mail refer this address.
|
|
|
|
|
Hi Everyone,
I have problem with printing envelopes using css(Stylesheet). Can anyone help me with a sample code for an envelope to print
Regards,
Manowj
|
|
|
|
|
CSS obviously formats how your page looks on the screen, which then is how it's going to print, but I'm not sure that you've worded your question well. What exactly is the problem ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
In CSS i have made settings for an envelope but on the screen, it shows the default legal size(A4) on the screen. The same is going to print
Regards,
Manowj
|
|
|
|
|
You can't make the window smaller, although you can set up the web page to be the size of an envelope.
A web page doesn't have a size, actually, it just keeps rendering while there's data to render.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi all
i have made and copied p3p policy files in a folder named "w3c" int the folder where my application is present.But in IE it still shows no privacy policy for my website.Can anyone tell me what am i may be missing?
Rama Charan Prasad
"Be happy and Keep smiling.Thats what u want be always..  "
|
|
|
|
|
HI friends ,
I am useing
Page P = Page.PreviousPage;
TextBox text = (TextBox)P.FindControl("TextBox1");
I am geting previous page's control if my previous page do not have masterPage.
But if my previous page is in masterpage then i am not getting previous pages control
i have also tried
TextBox text = (TextBox)P.FindControl("Contentplaceholder_TextBox1");
pls help me how to access controls of previous page.
|
|
|
|
|
cross page postback is a nasty hack. The fact that you have to do this at all, sucks. What if you write a recursive function that looks for TextBox controls in the Controls collection of the previous page ?
I sure hope you don't really have a textbox called TextBox1.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Well i guess!!
Check what is the prefix that ur masterpage is assigning to the contol..
Try checking the viewsource
along with the
Contentplaceholder_
thing it normally adds a lot of character and numbers to it..
Try doing this
kuwl_mark wrote: TextBox text = (TextBox)P.FindControl("Contentplaceholder_TextBox1");
replacing Contentplaceholder_ with the actual prefix..
Not still sure whether its work for the previous page thing but worth a try!!
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
