Comments by minal21 (Top 5 by date)

I think,to apply your above if condition (urDataGridViewName.Rows.Count >0) .
Select query should be changes as string t = "select Product1 from Product where product1=TextBox1.Text";

and then can continue with this
fd.fill(ds);
DataGridView.dataSource=ds; //U have a control DataGridView
if(urDataGridViewName.Rows.Count >0) //means records exist in database SoUpdat
{
//Now apply Update Query
}
else //Record not in database So Create query will applu
{
//Now Apply Insert Query
}

welcome :)

yes You Can...
Update your sp as
CREATE PROCEDURE [dbo].[client_billing_address_sp_update]
(
@in_type tinyint,
@vc_firstname_on_credit_card nvarchar(50) = ''
)
AS

declare @sql1 nvarchar(max)
IF(@in_type = 1)
BEGIN
set @sql1='insert into FCM_Claims(vc_firstname_on_credit_card) values(N'''+ @vc_firstname_on_credit_card + ''')';
END

try this function from your cs file

public Void InsertNonEnglish(string in_type,string vc_firstname_on_credit_card){
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

SqlConnection con = null;
try
{
con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("client_billing_address_sp_update", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] prm=new SqlParameter[2];

cmd.Parameters.Add("@in_type ", SqlDbType.TinyInt).Value = in_type;
cmd.Parameters.Add("@vc_firstname_on_credit_card ", SqlDbType.NVarChar, 1024).Value = vc_firstname_on_credit_card;

con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (con != null)
{
con.Close();
con.Dispose();
}
}

}

Hi,
Can you specify the type of input parameter you are providing(i.e non english characters)