Greetings,
I have just started learning the C Sharp language, based on what i already know from vb. im currently converting my website to c sharp, just to get a feel for the language, how ever im stuck.
the following vbcode, when converted to c sharp, does not recognise _param as a defined struct.. (eg: not giving any of the properties.)
when i go to type _param. i get no intellisense about the properties...Code:'VB Code: Dim _param As SqlParameter = hashEnum.Value objCommand.Parameters.Add(_param.ParameterName, _param.ParameterDataType).Value = _param.ParameterValue //C Sharp Code SqlParameter _param = hashEnum.Value; objCommand.Parameters.Add(_param.ParameterName, _param.ParameterDataType).Value = _param.ParameterValue;
and the entire code block...
can anyone help,Code:private string connectionString = ""; private SqlConnection objConnection = new SqlConnection(connectionString); private DataSet dtaSet; public struct SqlParameter { private string _name; private string _value; private SqlDbType _dataType; public SqlParameter(string Name, string Value, string DataType) { _name = Name; _value = Value; _dataType = DataType; } } public DataSet ReturnDataSet(string Query, Hashtable Parameters) { dtaSet = new DataSet(); try { SqlCommand objCommand = new SqlCommand(Query, objConnection); if (objCommand.Connection.State != ConnectionState.Open) { objCommand.Connection.Open(); } IDictionaryEnumerator hashEnum = Parameters.GetEnumerator; while (hashEnum.MoveNext) { SqlParameter _parameter = hashEnum.Value; objCommand.Parameters.Add(); } SqlDataAdapter adp = new SqlDataAdapter(objCommand); adp.Fill(dtaSet); objConnection.Close; } catch (Exception e) { } }
Thanks, Justin





Reply With Quote