hi, i am passing datetime.now.tostring() as parMETER IN MY SQL QUERY for retriving all the transaction of todays.but unable to retrive. please help me. my query like: select billno,net amount from bill_details where date='" +DateTime.Now.Tostring() + "'; THANKS IN ADVANCE.
sudhir behera
Posts
-
HOW TO RETRIVE ALL TRANSACTION from sqlserver where TODAYS DATE AS PARAMETER IN SQL QUERY.? -
how to display current time.hi, i am having problem in date time function while i am doing windows application.i am always getting date along with constant time 12:00:00AM.Which i dont want it.i want the exact time .plz give me some idea how can i do this in windows application. THANKS IN ADVANCE.
-
how to load data faster from Sql Server into comboboxhii, i have 134000 records in my table.i have binded one field in the combo box.when i am opening the page.it is taking 45 seconds to load data from sql serer into combo box.please help me how will make it faster.its urgents.i have to wait 45 seconds for making any transaction.
-
how to make call from software using c#hi,this is sudhir.i am doing a call center project software using c#.everything is complete.the main thing is to attain call from customer through software and also make call to customer.hows it possible?please give me some idea how to implement this features in my project.its important.
-
combobox filternation using c#hi,i have dynamically bind my table to a combobox.during runtime when i am typing any name in combox field it is unable to search.i have to select from drop down list.if combobox contain 2-3records easy if it contains more than 100 then how can i filter a particular name.plz give some idea.
-
i want to add listview item into database table or data tableplz give me some idea how to approach?plz its urgency..
-
i want to add listview item into database table or data tablehi,i have added some items into multicolumn list view.so i want to add all the row in listview into my database table or dynamically created table.plz help me.send me the code using c#.
-
how to bind listview data to dataset or datatable.?could u kindly send me the code in c#???
-
how to bind listview data to dataset or datatable.?hi,i have added some data to my listview.i want to add all the list view rows to a dataset or datatable using c#.please help me.give me the logic.
-
mouse click event of textbox??i have 3 textboxes.i want to give 2 nos in two textboxes and their result will display in 3rd textbox automatically after entering the 2nd no in second text box.result changes when i will update the data in corresponding textboxes.no button is dere.only 3 textboxes.plz send me the code.its urgent.plzzz
-
invoice form designbut i have designed a invoice windows form how can i convert it into crystal report?is this possible?i want my windows form to be printed in actual printing document.
-
invoice form designbut i will i add label, list box,textbox etc in crystal report.is this possible to design form in crystal report?
-
invoice form designhi,i am designing a invoice windows form in c# application.in this bill no is autogenerated from databse. date,sale type is dere.book id also in the form element.when i will type the book id then slno,book name,price will be added in list box.and discount total amount etc.but finaly i want to print the page.in billing only billno,date,sale type and listbox data will be dere.i am unable to do this.plz help me its urgent.if u have any billing invoice format and other procedure please give me the idea and logic.how to design a billing invoice for book shop?its urgent plz help me.
-
SPLITING A STRING LIKE 10/JULY/1988 AND BIND INTO 3 COMBOBOX SUCH AS DAY ,MONTH,YEAR.HELLO, MY STRING IS DD/MON/YYYY.I WANT TO SPLIT THIS STRING INTO INDIVIDUAL PART LIKE DD,MMM,AND YYYY.AND FINALY BIND THESE INDIVIDUAL VALUE INTO 3 COMBOBOXEX LIKE DAY,MONTH AND YEAR.I HAVE DONE THE CODE BUT ITS WORKING FOR SOME VALUE AND NOT WORKING FOR OTHER. MY CODE: string s = rows[6].ToString();//DOB LIKE 15/JULY/1988 int i = s.IndexOf("/"); t = s.Substring(0, i); t1 = s.Substring(0); t2 = s.Substring(i + 1, i + 2); int i1 = s.IndexOf("/"); t3 = s.Substring(i1 + 5); comboBox2.Text = t.ToString();15 comboBox3.Text = t2.ToString();JULY comboBox4.Text = t3.ToString();1988
-
how to build remote system call application ?hi,this is suhdir final year in computer science and engineering.i am doing a project for my final year.project is a chatting software.project details: software is similar to gtalk and diffrence is here conference call is possible.i have done the chatting part but one thing i am in delema how to make call??plz give me some idea how to make call.time is short in my hand.plz help me.
-
how to change instalation screenhi,i have build a setup file for my desktop application.i have put my banner on the top.but there is a default text like in welcome screen welcome to setup wizard.it is looking odd.i want to remove it.wht shall i do?plz help me...its urgent....
-
unable to instal my software in other machinehello,sir i have designed a software in c# .net.i have used the my sql databse.its working ok in my machine,becoz i have created it in my machine.packaging is ok.i have generated the sql script.when i am instaling this software instalation becomes successful,and also mysql databse.but when i am going to access the page its showing unhandle exception error.i have not used crystal report in my project.please help how will i instal it in other machine??its urgent.give me step by step procedure.
-
how to pass the textbox value as parameter in urlhello sir, i got an api for sending sms.i am implemneting it in my software.the hosting company has sent me the url and some codes.when pasting the url in my browser followed by my mobile no and message.then i am able to get the sms.but i have designed a windows form which contains 2 textboxes such as for mobile no and message respectively.and a send button.i want the mobile no and message from textboxes will pass as parameters in the url.how will i pass this value?please help my,its urgent. i am posting details of my code: ---------------------------------- private static string CALLURL(string url) { string Res = ""; try { HttpWebRequest gatewayReq; //Used for HTTP Request HttpWebResponse gatewayRes; //Used for HTTP Response gatewayReq = (HttpWebRequest)WebRequest.Create(url); gatewayReq.Timeout = 60000; gatewayReq.Method = "GET"; gatewayRes = (HttpWebResponse)gatewayReq.GetResponse(); Stream ReceiveStream = gatewayRes.GetResponseStream(); StreamReader sr = new StreamReader(ReceiveStream);//, System.Text.Encoding.ASCII); Res = sr.ReadToEnd(); MessageBox.Show("message sent successfully."); } catch { //Res = "URL is not responding at the moment."; //WriteErrorLog(DateTime.Now + "|" + "Call URL Function: " + ex.Message.ToString()); MessageBox.Show("Sorry,Unable to send Sms.Try Again Later."); } return Res; } private void send_Click(object sender, EventArgs e) { string url; string msg; Int64 no; no = Convert.ToInt64(textBox1.Text); msg = textBox2.Text; url = "http://203.212.64.15/genericpushnew/pushsms.aspx?userid=demo123&password=hotmail01&masking=CVRTNP&mobileno=no&message=msg"; CALLURL(url); } }