Comments by Manish Arya (Top 34 by date)

ok sir
fine
sorry again.

thanks sir
for open my eyes.

if i hearted you then sorry, its for my practice only.

Dear sir,
i am new in c#. i am learning the c# with visual studio. i want to try for creating a small project. if you are not intreseted for give me a example code then not a problem sir,pls tell me how it,s possible.

thanks

yes last record
means:
customer ID automatic generated like
CustomerId 1
CustomerId 2
CustomerId 3
CustomerId 4
CustomerId 5

now textbox1 =5 and then textbox2=6(which is currently used by the program)

thnks sir

sir pls tell me how?
what is the coding write in this program?

yes it is numeric. In varchar, All Character will be inserted (numeric,Character) but i want to only insert numeric value may be its blank. is it only way that i pass the 0 value in the textbox??

Dear Sir,yes i m using connection string. i m using the c# language.

i want to tell you what m i doing in this prject.

i m creating some window form and a parent form and connect through the connection string and its working fine in my single system. i want to know about this program could be run or not on the network when i m installed the client software in the first computer and database installed in the second system.

if it is not worked then how can be set the network property.

i m changing the datatype numeric to varchar.it's working.
but i want to write in numeric datatype and what is the different query.

yes its numeric and not null

same problem


private void btnSave_Click(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
SqlDataReader reader = null;
SqlConnection conn = null;

try
{
string query = "insert into CustomerTable values('" + txtCustomerName.Text + "','" + txtAddress.Text + "','"
+ txtMobileNo.Text + "','" + lblGoldBalance.Text + "','" + lblSilverBalance.Text + "','" + lblCashBalance.Text + "')";
conn = new SqlConnection(connstr);

if (txtCustomerName.Text != "" & txtAddress.Text != "")
{
conn.Open();
//Checking User Name Exists in CustomerTable

string query1 = "select txtCustomerName from CustomerTable where txtCustomerName='" + txtCustomerName.Text + "'";
SqlCommand cmd = new SqlCommand(query1,conn);
reader = cmd.ExecuteReader();

if (reader != null && reader.HasRows)
{
//User exists in db do something
MessageBox.Show("User Already Exists!!");
}

else
{
SqlCommand cmd1 = new SqlCommand(query, conn);
cmd1.ExecuteNonQuery();
txtCustomerName.Clear();
txtAddress.Clear();
txtMobileNo.Clear();
MessageBox.Show("Values Save in DataBase");
}
reader.Close();
conn.Close();
}
else
{
MessageBox.Show("Only Mobile Field Can be Empty");
}
}
catch (Exception ex)
{
MessageBox.Show("At Least 0 value can be save in the Gold Silver Cash Area", ex.Message);
}
finally
{
reader.Close();
conn.Close();
}

its working
thanks

yes i want just one time data save into database

i am using for insert above code:


private void btnSavePrice_Click(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string query = "insert into PriceTable values('" + txtPriceGold.Text + "','" + txtPriceSilver.Text + "')";
SqlConnection conn = new SqlConnection(connstr);

if (txtPriceGold.Text != "" & txtPriceSilver.Text != "")
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();

txtPriceGold.Clear();
txtPriceSilver.Clear();

MessageBox.Show("Values Save in DataBase");
conn.Close();
}
else
{
MessageBox.Show("Enter some value in the box");
}
}

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold=" + txtPriceGold.Text + "";
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);

using (SqlDataReader reader = objCommand .ExecuteReader())
{
while(reader.Read())
{
txtPriceGold.Text = reader["txtPriceGold "].ToString();
}
}
conn.Close();
}

Incorrect syntax near '='.

same problem.

Incorrect syntax near '='.

line is:

using (SqlDataReader dr = objCommand.ExecuteReader())

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+ txtPriceGold.Text + "";

SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);
using (SqlDataReader dr = objCommand.ExecuteReader())
{
bool success = dr.Read();
if (success)
{
txtPriceGold.Text = dr.GetString(1);
}
}
conn.Close();

error is:

Incorrect syntax near ','.

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold='" + txtPriceGold.Text + "'";

SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);
using (SqlDataReader dr = objCommand.ExecuteReader())
{
bool success = dr.Read();
if (success)
{
txtPriceGold.Text = dr.GetString(1);
}
}
conn.Close();

error is
"Error converting data type varchar to numeric."

private void txtPriceGold_Enter(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold='" + txtPriceGold + "'";

SqlConnection conn = new SqlConnection(connstr);

try
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql, conn);
using (SqlDataReader dr = objCommand.ExecuteReader())
{
bool success = dr.Read();
if (success)
{
txtPriceGold.Text = dr.GetString(1);
}
}

conn.Close();
}
catch (Exception)
{
MessageBox.Show("error");
}

same problem

pls give me a example code.

yes i m sure sir.

like

Manish
Manu
Toni
Twinkle

Dear sir,

i m using vs2008 and sql database.
i have a window form and i am creating a textbox and a database table, named EntryTable which have a column “customer name “.
I am add some data in this column like “manish, manu”. when I run the program and type in the textbox like “m” then its automatically show name “manish, manu”.

thanks sir i will try.

sorry sir i am trying many times but the link show a blank page.only its shows article posted by Amit Jain.

because i am not aware with the jquery and ajax toolkit

win application