ajinkya112

As it seems to come up often enough I figured I'd throw together a quick snippet outlining basic methods for data manipulation in SQL Server using C#. In all examples the coder will need to substitute their own connection string details and variables. I utilised parameters for 3 of the …

Hey Guys, I have a question... I want to display data from two different tables into a single datagrid view. Problem is i dnt wana join the tables. pls check this code [code]private void bindgrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str1 = "Select * from wcl_et "; str2 …

Hello all, It has been long since i am facing this problem. I want to convert my datagridview data to pdf format. I have searched a lot but couldnt find any. Need your help. Regards, Ajinkya

Hey people, I have a question. I may sound like a person with no knowledge. Isn't there any other control than datagrid or datagridview, to display data from table. Please help me to know more about this. Regards ajinkya

Hey guys, Here's the thing. I have a database in MS access. I have made an application that has to access this DB. Now this database is on another machine. Lets call it pc1. pc1 and my machine are in same wireless network. But when i try to connect to …

Hello people, I have an application that updates a table. In this application i have a combobox where i load id of record on form load. Let me paste my code to be more clear about my problem. [CODE] Private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string q = "Select …

Hey guys, I have an application that connects to DB that is on a remote PC. Problem is after a couple of minutes or so, it starts throwing exception. 1. The specified network name is no longer available. 2. Connection was forcibly closed by remote host. 3. connection was closed …

Hey guys, I have got a problem. I have an application that shows data in datagridview. Now, I want to add 'Print' option in it. I want to it print only those that are selected. I have tried a code but it didn't help at all. Please suggest me something …

Hey people, I have a simple application which inserts data into database. The database is located on a remote machine. However this machine(which has SQL) has a router installed. My pc(which has application) can find this machine's IP address by using a code. Everything is okay till this stage. Now …

Hey Guys, I have gotta problem. I want to store data into database(which i can do) from C# application. Now the thing is every time I insert or update, I want my application to catch that transaction, create a 'TRANSACTION ID', and store it in table. So that it would …

Hey guys, I have written a code that could delete selected row in data grid view. I gives lots of errors. Let me paste my code. [CODE]for (int i = 0; i < dataGridView1.Rows.Count; i++) { DataGridViewRow dr = dataGridView1.Rows[i]; if (dr.Selected == true) { dataGridView1.Rows.RemoveAt(i); cmd.CommandText = "Delete from …

Hey Guys, I am now loosing my cool over this problem. let me paste my code an then i'll explain my problem. Here's my code : [CODE] if (rn < ds1.Tables["Company"].Rows.Count-1) { rn = rn + 1; textBox1.Text = ds1.Tables["Company"].Rows[rn].ItemArray[0].ToString(); SqlDataAdapter da1 = new SqlDataAdapter("Select C_ID from Company where C_NAME …

Hi everyone, From couple of days i am trying to write a code that would generate Id automatically and store it in table. I have a table "STU". It has two columns Id and Name. I have taken a form which has two text boxes and a button. text box1 …

Hey guys, I am trying to write down a code for generating 'ID' automatically and then store it in table. There some errors, i couldn't rectify. This is my code : [CODE] int ctr = 1; int len; DataTable dt = new DataTable(); DataRow dr; DataSet ds = new DataSet(); …

Hey guys, I need a code that would delete the row from not only from grid view but also from the table. I am able to delete the row from grid view but its not getting deleted from table. Any suggestions on how to do it. Regards Ajinya

Hey people, I have a database that is stored on a remote machine. In my application i have used connection string with IP address of that remote machine. Now, the problem is every time the remote machine is turned on it has a new IP address. Is there any way …

Hey guys, I have two forms, form1 and form2. My form1 has a combo box and a button. Here's form1 code. [COLOR="Red"][B]Form1[/B][/COLOR] [CODE] public partial class Form1 : Form { bool s; public Form1() { InitializeComponent(); s1 = comboBox1.Text; } private void Form1_Load(object sender, EventArgs e) { } public string …

Hey people, I want to make an application which would be connected to a database. It would retrieve data make changes and store it in database again. I have figured on how to make this application. But the real catch is i want database to be stored on a single …

I need to know if it is possible to store click event of a button in a variable. I tried doing it but didn't get any solution. Please help Regards

Hi people I need some help here. Here is the CODE : [B]for Form1:[/B] [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace practice { public partial class Form1 : Form { Form2 obj; public Form1() { InitializeComponent(); } …

Hey Guys, Currently, I am doing a project. I don't know how to pass a value from one windows form to another windows form using c#.net. Suppose, I have two forms parent form and child form. Parent form consists of a combo box & button and I want to pass …

Hey guys, need your help once again. I want to create a global variable in one form and then use it in another form. I need to know of it is possible. If yes, then how do we do it. Thanks And regards

Example : suppose i have a form1 and a form2. form1 has a button on it which would display a message "Clicked" when clicked And if form2 inherits form1. How can i change the properties of that button and make display a message "Now Clicked" ? please help.....:?:

How do i create two tables in a database at same time from a windows form.?? how do i give them same name??

Delete selected record on Button click. I am using MS Access as a Database in C#. How it can be done ??

i need to ask one more question.... [CODE]private void bbn_Click(object sender, EventArgs e) { OleDbDataAdapter ad; DataSet ds1 = new DataSet(); if (comboBox1.SelectedIndex == 0) { string str1 = "select * from '"+comboBox1.SelectedIndex+"'"; OleDbConnection conn1 = new OleDbConnection(str); ad = new OleDbDataAdapter(str1, conn1); ad.Fill(ds1); dataGridView1.DataSource = ds1.Tables[0].DefaultView;[/CODE] i want the …

Hey folks, I am making an application where i want to create some controls dynamically. for instance..i hv a text box that takes the name of table and stores it in database. Now, the thing i want is everytime a name is added and table is created...at the same time …