I've to load list of states in a combobox from sql stored procedure how to this?

				DataTable objTbl=null;

				try
				{		
					string sConnectString =  "PROVIDER=SQLOLEDB;" +
						" DATA SOURCE = " + <Your Database Server> + ";" +
						" INITIAL CATALOG = " + <Database Name> + ";" +
						" USER ID= " + <Database User> + ";" +
						" PASSWORD = " + <Database Password> + ";"; 

					OleDbConnection objCon = new OleDbConnection();
					objCon.ConnectionString= sConnectString;
					OleDbCommand objCmd = new OleDbCommand();
					objCmd.Connection = objCon;
					objCmd.CommandType= CommandType.StoredProcedure;
					objCmd.CommandText = <Your ProcedureName>;
					OleDbParameter objParam;
				
					objParam = objCmd.Parameters.Add("RETURN_VALUE",OleDbType.Integer);
					objParam.Direction=ParameterDirection.ReturnValue;			
					
					objCmd.CommandTimeout=0;
					objCon.Open();
					DataSet objDs = new DataSet();
					OleDbDataAdapter objAdap = new OleDbDataAdapter(objCmd);
					objAdap.Fill(objDs,"DATA");
					objTbl = objDs.Tables["DATA"];
					objCon.Close();
					combobox.DataSource = objTbl;
				}
				catch(Exception ea) 
				{
					throw ea;
				}			

---

Please mark the post as answer if it is helpfull to you because it boosts the members to answer more and more.

				DataTable objTbl=null;

				try
				{		
					string sConnectString =  "PROVIDER=SQLOLEDB;" +
						" DATA SOURCE = " + <Your Database Server> + ";" +
						" INITIAL CATALOG = " + <Database Name> + ";" +
						" USER ID= " + <Database User> + ";" +
						" PASSWORD = " + <Database Password> + ";"; 

					OleDbConnection objCon = new OleDbConnection();
					objCon.ConnectionString= sConnectString;
					OleDbCommand objCmd = new OleDbCommand();
					objCmd.Connection = objCon;
					objCmd.CommandType= CommandType.StoredProcedure;
					objCmd.CommandText = <Your ProcedureName>;
					OleDbParameter objParam;
				
					objParam = objCmd.Parameters.Add("RETURN_VALUE",OleDbType.Integer);
					objParam.Direction=ParameterDirection.ReturnValue;			
					
					objCmd.CommandTimeout=0;
					objCon.Open();
					DataSet objDs = new DataSet();
					OleDbDataAdapter objAdap = new OleDbDataAdapter(objCmd);
					objAdap.Fill(objDs,"DATA");
					objTbl = objDs.Tables["DATA"];
					objCon.Close();
					combobox.DataSource = objTbl;
				}
				catch(Exception ea) 
				{
					throw ea;
				}			

---

Please mark the post as answer if it is helpfull to you because it boosts the members to answer more and more.

Hi sudhir,