Comments by waqar ahmad (Dev) (Top 11 by date)

I open it but still giving exception
System.Data.SqlClient.SqlException: Incorrect syntax near 'CustomerGroupContacts'.
Actuallay i have two tables
The id is one table1 and description in another table2 and i have to bind ID value dd.DataValueField from table1 and and description dd.DataTextField from Table2

My Code is for Filling Customer DropDownlist is
it giving error on dataset
public void FillCustomer(DropDownList ddsuplier)
{
DataSet ds = new DataSet();
using (SqlConnection con = ConnectionManager.GetConnection())
{
using (SqlDataAdapter da = new SqlDataAdapter("SELECT " +
"CustomerGroupContacts.cusg_id, " +
"CustomerGroupContacts.cusg_id+'___'+CustomerIDs.cusid_name as customername" +
"FROM " +
"CustomerGroupContacts INNER JOIN " +
"CustomerIDs ON CustomerGroupContacts.cusg_id = CustomerIDs.cusg_id", con))
{

da.SelectCommand.CommandType = CommandType.Text;

da.Fill(ds, "CustomerGroupContacts");
if (ds.Tables.Count > 0)
{
ddsuplier.DataSource = ds;
ddsuplier.DataTextField = ds.Tables["CustomerGroupContacts"].Columns["customername"].ToString();
ddsuplier.DataValueField = ds.Tables["CustomerGroupContacts"].Columns["CustomerGroupContacts.cusg_id"].ToString();
ddsuplier.DataBind();
}


}
}
}

Query is working in Sql server Query Editer and also shows data

Customer cusg_id char(4) its not integer

System.Data.SqlClient.SqlException: Incorrect syntax near 'CustomerGroupContacts'.

Source Error:


Line 30: {
Line 31: da.SelectCommand.CommandType = CommandType.Text;
Line 32: da.Fill(ds, "CustomerGroupContacts");
Line 33: if (ds.Tables.Count > 0)
Line 34: {

I fix my problem from your reply. I set decimal(8,4) for decimal value 4,4. Now when these values saved, are automatically round off e.g when I enter value 2.369 it will convert automatically 2.3700. I want to prevent it for automatically conversion.
Hope you have solution of my problem