what the idea of internet printing in C#

i have a some lines of code in the button which is providing a functionality of saving data into database.I like to do the same funtionality(saving data into database),what i have to do.,write the same code in menu item ???? or any shortcut way to complete this task.

i am connecting with sqlserver database ,then i need to acces that user which is in my textbox ,but no user comming from it. code is as follows: sqlConnString="server= your server; database= ;user id=;password=;"; sqlConn = new SqlConnection(sqlConnString); sqlConn.Open(); sqlCmd = new SqlCommand(“select username,password from table where username=@textbox1.text”); sqlDataAdapter da = new SqlDataAdapter(); da= cmd.executeReader() If da.read() { responser.redirect(“loginsuccess.aspx”) } else { response.write(“invalid login.aspx”) } ++++++++++++++++++ error is System.Data.SqlClient.SqlException: Must declare the variable '@TextBox1'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ASP.UserInfo_aspx.Page_Load()

i am connecting with sqlserver database ,then i need to acces that user which is in my textbox ,but no user comming from it. code is as follows: sqlConnString="server= your server; database= ;user id=;password=;"; sqlConn = new SqlConnection(sqlConnString); sqlConn.Open(); sqlCmd = new SqlCommand(“select username,password from table where username=@textbox1.text”); sqlDataAdapter da = new SqlDataAdapter(); da= cmd.executeReader() If da.read() { responser.redirect(“loginsuccess.aspx”) } else { response.write(“invalid login.aspx”) } +++++++++++++++++++++++++++ error is this System.Data.SqlClient.SqlException: Must declare the variable '@TextBox1'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ASP.UserInfo_aspx.Page_Load()

well sir i got yours point ..i am using windows 2003 server as operating system..wat i have to do to connect the database (sql server200) in asp.net. plz tell me the steps that which code of lines should be written where???or wat i do with theuser etc plz help me in some way. With best wishes Ishtiaq Ahmed

hi all; I am trying to connect sql server2000 with asp.net(C#). but nothing happens. Actual problem comming from connection string which is not coming to solve my code is as follow: <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Page language="C#" %> void Page_Load() { string my="workstation id=HOME;packet size=4096;integrated security=SSPI;data source=HOME;persist security info=False;initial catalog=PrintQuota"; SqlConnection mycon=new SqlConnection(my); try { mycon.Open(); TextBox1.Text="Connection opend successfully"; mycon.Close(); } catch (Exception g) { TextBox1.Text=g.ToString(); } } The main problem is with user id and password,, i have also checked with integrated security=SSPI but no way to connect..the same string i use in window application but its work but here in web app its not working error message from exception is error System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.UserInfo_aspx.Page_Load() in http://localhost/WebApplication1/UserInfo.aspx:line 16 plz solve my problem . i m waiting for replies. with regards Ishtiaq

hi all; I am trying to connect sql server2000 with asp.net(C#). but nothing happens. Actual problem comming from connection string which is not coming to solve my code is as follow: <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Page language="C#" %> void Page_Load() { string my="workstation id=HOME;packet size=4096;integrated security=SSPI;data source=HOME;persist security info=False;initial catalog=PrintQuota"; SqlConnection mycon=new SqlConnection(my); try { mycon.Open(); TextBox1.Text="Connection opend successfully"; mycon.Close(); } catch (Exception g) { TextBox1.Text=g.ToString(); } } The main problem is with user id and password,, i have also checked with integrated security=SSPI but no way to connect..the same string i use in window application but its work but here in web app its not working error message from exception is error System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.UserInfo_aspx.Page_Load() in http://localhost/WebApplication1/UserInfo.aspx:line 16 plz solve my problem . i m waiting for replies. with regards Ishtiaq

hi experts i have a string let say string dummy="hello" i want to remove 'h' and 'e' from this string and want to show a remaining string "llo" on the messagebox. waiting for reply

I am on the network with two computers,i want to send messagebox message to another computer..how it will occurs. waiting for reply

Hi all experts,,,, i have a problem,that i have developed a module(window application) in which there is a tree control.In tree control there are items in nodes of tree control.I want to select the item and do right click on that item and i got a popmenu.means that as the menu we use in our common applications which contain cut,copy etc. Plz help me as soon as possible. With regards Ishtiaq Ahmed

it simple. let say i have button on my form,,,,and i have two messageboxes on my button click..i need to do that when ever i click my button,1st message box appears and 2nd message box appears after 10 sec .

sit this i have checked..its hapeening every 10 sec.but i need to do is that it should be executed 1ce after 10 sec. i.e eg when i cliked on button which have two message box,then after first messagebox ,second messagebox appears after 10 sec....in this case t1.Elapsed += new System.Timers.ElapsedEventHandler(ont1); if i remove '+' then it can be possible but it cant. so i need to execute like this way

how the timer can be used???????????????????????? It has lot of classes>>>>and members please tell something in detail

I want to know a question from you that i want to apply a timer between my code. you help me please. means that for example i have two lines of code let say. console.writeline("hello1); console.writeline("hello2); Now i wana to do that after 10 seconds console.writeline("hello2) executes(not every 10 sec). console.writeline("hello1);; //timer of 10 sec// console.writeline("hello2); Means that when console.writeline("hello1) then after 10 sec console.writeline("hello2) should be executed.. Please help me ,, i m very near to my destiny. with regards Ishtiaq Ahmed

I want to know a question from you that i want to apply a timer between my code.ca you help me please. means that for example i have two lines of code let say. Method1(); Method2(); Now i wana to do that after 10 seconds the Method2 executes(not every 10 sec). Method1(); //timer of 10 sec// Method2(); Means that when Method1 then after 10 sec Method2 should be executed.. Please help me ,, i m very near to my destiny. with regards Ishtiaq Ahmed

I want to know a question from you that i want to apply a timer between my code.ca you help me please. means that for example i have two lines of code let say. Method1(); Method2(); Now i wana to do that after 10 seconds the Method2 occurs(not every 10 sec). Method1(); //timer of 10 sec// Method2(); Means that when Method1 occurs then after 10 sec Method2() should be executed.. Please help me with regards Ishtiaq Ahmed

hi experts ,, i wana know that how to add a existing class in a windows application project in C#.and how to use it by making objects or watever.. i hope u will understand. waiting for yours reply. plz make a simple application with a button that i can understand easily(make any class declaration and add it) ishi_us@yahoo.com

*How to monitor a printer queue from C# *Get a handle to the printer you want to monitor ==================================================================== HI Experts, how are you .hope you all will be fine.. i have started that i have to work on C#.well sir my project in which my main motto is to pause,cancel, and delting a job.. i have done the RND of this topics and methods used in the project... Well sir now i am in the way that i have to know about the event handlers,event watcher for the printjobs or printers.In other words that when the user give the command of printjob then this job is watched by the event watcher and the information of printer i.e printer handler is given to the the event handler like jobid and according to this watching information of job the users jobs should be pause,cancel or delete the job.I have to handle with event wathcer , not from the button of the form,,because the job should be captured as before the printer starts and the action i.e performed pause or delete or resume .Now i am on the phase that i have to start working on handlers ,needs yours help.Waiting for yours reply . With Regards, Ishtiaq Ahmed

well sir sure i like to take urs help...i have just reaced to my destiny as well but some problems occuring in it..... i m writing here u code and plz try to help me...The problem occuring on following places..please read code i m writing where the problem is occuring.. /////////////////////////////////////////////////////////////////// try { PropertyDataCollection __gc *pdc = e->NewEvent->get_Properties(); PropertyDataCollection::PropertyDataEnumerator __gc *pdce = pdc->GetEnumerator(); while(pdce->MoveNext()) { PropertyData __gc *pd = pdce->get_Current(); ManagementBaseObject __gc *mbo = dynamic_cast(pd->get_Value()); 1) problem***************problem occuring on the below if statement.not all time but some time the mbo variable does not declare and by using watches i see that mbo is undeclared value.its some time ... and printer does not pause..*********************************** if( mbo != NULL && mbo->ClassPath->ToString()->ToUpper()->EndsWith(S"WIN32_PRINTJOB") ) { ///// //pause job long a=0; long *hprinter = &a; for(int i=0 ; iprintersname->Length ; i++) { try { int result = PrinterAPIs::OpenPrinter(this->printersname[i], hprinter, NULL); bool resultf = PrinterAPIs::SetJob(*hprinter, (long)Int64::Parse( mbo->Properties->get_Item(S"Jobid")->Value->ToString() ), 0, NULL, 1); PrinterAPIs::ClosePrinter(*hprinter); MessageBox::Show(this, mbo->Properties->get_Item(S"Owner")->Value->ToString()); ***************************************************************************** 2) Below message box is not showing the correct number of pages that comes from print status that come in task bar when a pages are going to print.*************************************** MessageBox::Show(this, mbo->Properties->get_Item(S"TotalPages")->Value->ToString()); if(resultf == true) break; } catch(Exception __gc *ex) { MessageBox::Show(this, ex->ToString()); ex = NULL; }

Hi all, i am developing a software ,,which will helpfull for the network administrator in such a way that....it will provide efficiency to the printer.. my software is explained as this software will restrict the user to use the printer....for example... the network administrator will provide a database for the user that e.g, "abc" user can only print 3 pages...if user send 4 number of prints from any place means from network or any software then then the message box come to the user that u r restricted to use on 3 pages...the boundries of such software are completed.....the main module that when the user send the print job to printer then the job should cancelled and read the database and according to that data base there will be printing pages to certain users... So i have to take help that ....plz made me this help that this module i m tying a lot ..but not happening that the job should canelled first of the printer and then job according to database apply...please programmes help me .I will very thankful to all...I will wait for yours response and the code also related to this module.. Lot of thanx for solving my problem