aayu - Professional Profile

 private void combobox_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlConnection cnn1 = new SqlConnection(@"");
            cnn1.Open();
 
            DataSet da = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter("select * from table you want", cnn1);
            sda.Fill(da, "Tablename");
 
            //  for (i = 0; i < da.Tables["tablename"].Columns.Count; i++)
            int i = 0;
            for (i = 0; i <= da.Tables["tablename"].Columns.Count - 1; i++)
            {
                string strcolumn = da.Tables[0].Columns[i].ToString();
                string strvalue = da.Tables[0].Rows[0][i].ToString();
 
                
                if (combobox.SelectedItem.ToString() == "columnname")
                {
                    if (combobox.SelectedItem.ToString() == strcolumn)
                    {
                        label5.Text = strvalue;
                    }
 
                }
                else
                {
                    if (combobox.SelectedItem.ToString() == "columnname")
                    {
                        if (combobox.SelectedItem.ToString() == strcolumn)
                        {
                            label5.Text = strvalue;
                        }
                    }

    {
        //sql connection
        SqlConnection cnn = new SqlConnection();
        cnn.ConnectionString = "Your connection";
        cnn.Open();
        SqlCommand cmd = new SqlCommand("select mobileno, password from register where mobileno='"+txtmoblie.Text +"'and password='"+txtpassword.Text+"'",cnn);
        cmd.Connection = cnn;
        SqlDataReader dr = cmd.ExecuteReader();
 
        if (dr.Read())
        {
            Response.Redirect("http://www.google.com");
        }
        else
        {
            Response.Write(@"<script language="'javascript'">alert('Invalid Username and Password')</script>");
            
        }
        cnn.Close();
       
 

    }

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 MIC
 public Form1()
        {
	 InitializeComponent();
         }
 
public SqlConnection getsqlcon()
        {
            string connstring = "Server Name";
            SqlConnection con = new SqlConnection(connstring);
            return con;
        }      	
 
public bool getcomm(string connstring1)
        {
            try
            {
                SqlConnection sqlcon = this.getsqlcon();
                SqlCommand sqlcomm = new SqlCommand(connstring1,sqlcon);
                sqlcon.Open();
                sqlcomm.ExecuteNonQuery();
                sqlcomm.Dispose();
                sqlcon.Close();
                sqlcon.Dispose();
                return true;
 
            }
            catch(Exception ex)
            {
                return false;
            }
 
 private void btnsubmit_Click(object sender, EventArgs e)
        {
	try
            {
                string col1 = dataGridView1[0, dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string col2 = dataGridView1[1, dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string col3 = dataGridView1[2, dataGridView1.CurrentCell.RowIndex].Value.ToString();
                string col4 = dataGridView1[3, dataGridView1.CurrentCell.RowIndex].Value.ToString();
               // string col5 = comboBox1 4,comboBox1.SelectedItem.ToString();

                string insert_sql = "insert into clientwiseproductwise(col1,col2,col3,col4)values('" + col1 + "','" + col2 + "','" + col3 + "','" + col4 + "')",con;
 
                if (this.getcomm(insert_sql))
                {
                    MessageBox.Show("Insert Success");
                }
                else
                {
                    MessageBox.Show("Insert Failed");
                }
            }
            catch
            {
 
            }