virusisfound

I was working on C# windows application as front end and SQL as back end I have display my sql table data in dtatgridview. [B]I want to display the data in textbox whatever row i select in datagridview.[/B] I have write some code but its not showing data in textboxes. …

hi I am virusisfound. I have read all the post all u entered. I find it's quite interesting . I am also interested to find some thing more about it.. I want to know how can I send SMS as u all discussed before what changes. I have to perform …

hello. I want to delete my thread I already marked it as bad flag. but as soon as possible i want to delete my thread please tell me how can i delete thread.

How to divide a number into multiple parts so that the resulting sum is equal to the input? for ex : input from textbox : first input is(txt_val1) :5 second input is(txt_val2) :3 output : 3+2=5 2+3=5 4+1=5 1+4=5 or any other combinations like these. both input are dynamic always.

if you want to place multiple panels on same location. you can set fixed location for all panels and set all panels location property to same.

Hi.. I am trying to create question paper generator application in C# windows application with sql server as back end. Now I need your help to select the questions from database. Ex: User Selection like: Chapter selection from listbox then select 1 mark – 5 question 2 mark -3 questions …

Hi, I am working in C# windows application. and I want to compare datagridview value before add the row in dgv. dgv is non editable,i am programitaclly adding row in dgv. like: dgv_data.Rows.Add(txt_id.Text, txt_itemname.Text, txt_qut.Text, txt_prc.Text,tot);//here tot is for calculate total amount(qut*prc) now i want to comare txt_id value with …

Hi all, I want to create a crystal report. Before print the document I want to see the output first, and then give the print command. On print button, But the problem is I have dot-matrix printer and I the page size is fix. So how can I overcome this …

how to create a discussion pages. like a blog and how to post comments on that or a small chat room. I am new in asp.net so any one can provide me some code or link where i can learn this. I want this for learning purpose so please help …

hi,,, I am learning the asp C# web application. so I really don't have enough knowledge to develop code for blogging. I want to create a web page where my log in members can create their own blogs. and post comments on that. so can u please help me out. …

how to update datagridview in C# windows application. I want to update the rows in datagridview. I have 1textbox, 1gridview, and button. Before saving the data I want to make additions of textbox value and datagrid value. if i enter 20 value in textbox. the value should be add in …

hi, I am working in C# windows application as front end and sql server 05 as back end. I want retrieve image from database. Image,imagenm, image path save in the database. The code given below shows an error message i.e [B]Unable to cast object of type 'System.String' to type 'System.Byte[]'.[/B] …

I don't know how to solve this problem. I want to create simple project in visual studio 08 in C# windows application which can save update delete data from database. here are the steps i use : open new project right click on solution explorer -add- add new items-service-based-database when …

Hi, I am working in C# windows application & I have one [B]combo box[/B] which have the list of items. and one [B]datagridview[/B]. now I want to [B]add new rows[/B] as i [B]select the combo box items[/B]. The number of row add in datagridview till i select the items from …

I am working in SQL 2005 I want to Create view for one table. Table Name abc 1. id 2. name 3. percentage 4. marks How can i create view for one column I want to search the name and makrs and name and % both have searching on name …

I want to pass multiple select queary to datareader. how to do it. I know how to pass queary for one condition : [CODE] SqlConnection cn = new SqlConnection(); cn.ConnectionString = ""; cn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader rdr; string s = "select * from abc where id like@find"; …

timer i have two labels in C# windows Application and i want make it visilbe for once. on form load : label1.visible = true; label2.visible.false; and on timer tick event: label1.visible.false; label2.visivle = true; now after it perform one tick it display another form. how to do it. in my …

I am working in sql server2005 and c# I have five database in my project and I want to display one table from each database in one datagridview. How can i do it.

[CODE] SqlConnection cn = new SqlConnection(); cn.ConnectionString = "pathof your database"; cn.Open(); SqlCommand cmd = new SqlCommand("create databse"+textBox1.Text); cmd.ExecuteNonQuery(); cn.Close();[/CODE] this code is for create database at run time and u can spacify the database name in textbox. I think u need this code.

How can I change the app.config file path at run time. When user select the name and enter the passward. Please can any one provide me some code for that. Like a login form.

I have table abc In taht I want to add colunm at run time. I have done some code but there is an error [CODE]SqlConnection cn = new SqlConnection() ; cn.ConnectionString = ""; cn.Open(); SqlCommand cmd = new SqlCommand("alter table abc add" + textBox1.Text.ToString() + "varchar(500)",cn); cmd.ExecuteNonQuery(); SqlCommand cm = …

I have done some calculations in two textbox data type is double like 9/8 The answer is in point [B]1.125[/B] how can i make it in complete value. like if it is less than .5 it take 1 as complete number. or if the answer is above .5 then it …

[CODE]SqlConnection cn = new SqlConnection(); cn.ConnectionString = ""; cn.Open(); SqlDataAdapter da = new SqlDataAdapter("slect * from table name where date=@date", cn);//If you want to display some field of tahe then put the name of taht in the queary. da.SelectCommand.Parameters.Add("@date", SqlDbType.NVarChar, 20); da.SelectCommand.Parameters["@date"].Value = textBox1.Text.ToString();// spacify the control name from which …

Hello, I want to save multiple record in database from DataGridView. I have some code but their is an error i.e [B] Column named id cannot be found. Paramater name:columnName[/B] [CODE]SqlConnection cn = new SqlConnection(); cn.ConnectionString = "path of connection"; cn.Open(); string q = "select * from abc"; SqlDataAdapter da …

I an working in C# windows application. I have a task to perform i.e. [B]I have to print the crystal report from datagridview control.[/B] What ever data present in datagridview it shows in crystal report. When I click the print Button. Is it is possible. If yes please tell me …

as per your posts I think the size of datetime filed in database tables is small. either increase the size of that field in database tables or set [B]format property of datatimepiker[/B] to [B]short[/B].

how to disply last enter data of a particular name like table name = abc contents in the table : 1.abc 2.pqr 3.abc 4.xyz now in visual studio i want to search last enter data of abc

To do this task you have to calculate the difference between book_due date and returned_date then you can calculate the due. you have to take datetimepicker the following code will calculate the difference between issued_date with current date. Here is code to calculate the difference between two dates: [CODE]DateTime dt …

I am studding about Connected environment and Disconnected environment. I have one question i.e. projects that are create in Connected environment are goes long time reliable. Or disconnected. Not only for practice but in live projects also.

I have two forms and i have retrive controls from one form to another. In form 1 Two controls 1 datetimepicker1 2 datetimepicker2 in form 2 1 Datetimepicker1 now i retrive form1 controls on form2 and i want to compare form1 datetimepicker with form2 datetimepicker. here is code: /[CODE]Form2 fr2 …

I am working in C# windows application and SQL I have one problem i.e I want to know that can we search data directly from database. for table we write a queary = Select * from tablename. like that is there is any queary to directly search from entire database …

if the error on deletion then I think this code help you write tis code on datagridview [CODE]dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;[/CODE] On any button or any control click event write this code [CODE]DataGridViewRow row = dgv.SelectedRows[0]; dgv.Rows.Remove(row);[/CODE] and if you get error on connectionstring then show what procedure you use.

I want to search data from combo box here is the code : [CODE]SqlConnection cn = new SqlConnection(s); cn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataReader rdr; string cd =comboBox1.Text.ToString(); string CommandText = "select * from rto where cd =@cd"; cmd = new SqlCommand(CommandText, cn); cmd.Parameters.Add(new SqlParameter("@cd", System.Data.SqlDbType.VarChar, 20, "cd")); cmd.Parameters["@cd"].Value …

I want to print date when user give start date to end date period. if user give 3 month period then the date should print like 1/1/2011 1/2/2011 1/3/2011 This date print properly but I want to save that date in table. like the three dates are their so in …

I have ten tables in database I want to combine that tables in one crystal report. I know the coding for one table that is not work for multiple tables. When I run the application then the report is blank.

I have two problems 1. I have develop and Installed a project on my computer. that was work on my PC so many days. but now prject not work properly. It give me error message that [B]SQl connection not avaliable.[/B] Is their is any way to overcome this problem. Can …

I want to display my table columns and data in datagridview at run time when user select table name I know that i have to set bindingsourse property . But i dont know how to do programming for that can you tell me.

I want to add new field when user enter text in text box and click on create then in the database table new field is create with the name present in text box I use this code to do this but it takes a8 as new field can i use …

I am using C# as front end and sql as back end. EX. table name employee feilds = empid,nm,add I want to search code 003 if it present in database it show me message that this data is present and search for last empid+1 as empid. other wise if code …

Is It Possible to show date if user specify the start date and then in text box user specify the number of month. then the date should be print like : ex : user give date 1/1/2011 In text box he enter 10 month then output will be like 1/1/2011 …

you can directly perform the calculation on crystal repot In Feilde Explorer - right click on formula feild - spacify the name(EX. total). double click on the feild that you want to perform the operation if a1 +a2 +a3 = a4 drag and drop feild as your spacified name(total) But …

Hi, I want to save datagridview data in Excel sheet as per user spcify the location for that I write some code but It's not working properly. If I spacify the location in the code then It alway overwite the data on previous data. In Savedialog Box when I spcify …

Hi, I am working on a project in that I am using C# and SQL as front & back End. I want to copy my all old data in my new project. and now I dont have SQL in my system. How can I copy my data please help me …

Hi, I am working on one inventory control project in that I have one combo box in the combo box I am showing all the product name but in database their is duplication of product name when user sale one product then it save in the table. So the user …

I am using C Sharp for front end and Access as back end. In the sales table I want to enter weight in folating point number. It calculate the total properly but at the time of saving it display error message that Input string was not in correct format. I …

Hi, I am working on tree View in taht i want to do two thinks i.e 1. add new node at run time 2. what data is stored in a database is shown in the tree view as parent node and its child for second i have do some coding …

Hi, I want to print one bill from crystal report but by default crystal report have the A4 size paper but i need only 6 X 6 paper size. How can I set the size for crystal report. I seen that when we select the print option the print option …

Hi, I am working on a project in that I want to dispaly the avablible quantity from database. I have write some code for that code is working. but It display entier data from frist row to last. I want to display only particular item avaliable quantity. can any one …

If you are using [B]calender control [/B]then use the [B]TimeSpan[/B] property. Get one Calender Control,textbox and Button. [CODE] dt = Calendar1.SelectedDate ts = Date.Now - dt TextBox1.Text = ts.Days.ToString [/CODE] dt is object of datetime, ts is for timespan This code in Visual Studio Visual basic.

Hi, How to globlize the form.