Comments by adityaimmadi

adityaimmadi 24-Oct-13 15:52pm View

sir,i already tried it before posting the question
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);---at this line i got error in converting nvachar value to it int.thats why i changed above line
DataList1.DataSource = ds;
DataList1.DataBind();

adityaimmadi 24-Oct-13 15:41pm View

yes sir,it contains some random numbers and letters.what can i do now ,why this happens..
can you please tell me the solution...
Thanks in advance

adityaimmadi 1-Oct-13 14:57pm View

the value is encoded sir and type is string...
Thanks and Regards

adityaimmadi 1-Oct-13 14:52pm View

Thanks sir,i'll change it defnetly...

adityaimmadi 1-Oct-13 14:51pm View

Sir,i have changed my code like this
foreach (var keyValue in SPParamWithValues)
{
cmd.Parameters.Add(keyValue.Key, SqlDbType.Int).Value = keyValue.Value;

}
comd.CommandType = CommandType.StoredProcedure;
comd.Parameters.AddWithValue("@id", id);
using (var da = new SqlDataAdapter(comd))
{
da.Fill(table);
}
}
thenn it says Error converting data type nvarchar to int.in my table id datatype is int ,i spend coulpe of hours for this,can you please helpp me
Thanks and regards

adityaimmadi 27-Sep-13 15:19pm View

public DataTable GetTable(string SPName, Dictionary<string, object=""> SPParamWithValues)
{
SqlConnection conn;
SqlCommand cmd;
SqlDataAdapter adapter;

DataTable dataTable = new DataTable();

conn = Provider.GetConnection();
//open DB connection
conn.Open();-----at this line i got error like connection string not intialized

Thnaks and Regards

adityaimmadi 27-Sep-13 15:16pm View

public DataTable GetTable(string SPName, Dictionary<string, object=""> SPParamWithValues)
{
SqlConnection conn;
SqlCommand cmd;
SqlDataAdapter adapter;

DataTable dataTable = new DataTable();

conn = Provider.GetConnection();
//open DB connection
conn.Open();---at this line,it shows connection string error.

Thanks and Regards

adityaimmadi 26-Sep-13 15:29pm View

That means my web.config?? it works fine for all the other pages .in this DataClass.cs only i'm facing the problem.thats why i came for help.i ust want to know what is wrong with my code sir.
Thanks and Regards

adityaimmadi 17-Sep-13 16:18pm View

sir,my scenario is registering user verifying againest database and inserting his personal details except his id and name (need to get these two from session ).i dont know how to bring name and id using sessions i tried above code then 'm getting errors like this.can you please suggest me how to overcome this

adityaimmadi 17-Sep-13 15:46pm View

sorry for the above code , this is not the real one but it is actually a sample one like my original .the question you asked "When do they initially get stored in session?"is actually my problem.
string name = Session["nameforlogin"].ToString();
// string id = Session["id"].ToString();
if i write above 2 lines in page load it returns the error like "Object reference not set to an instance of an object".

can you please help me
Thanks and Regards

adityaimmadi 12-Sep-13 9:40am View

Thanks for your advice

i'm not asking about whole the code.just give me the hint or somethhing

Thanks and Regards

adityaimmadi 30-Aug-13 11:42am View

as a 6 months exp. fellow ...i dont know how to start on this problem can you please suggest me...
thanks

Comments by adityaimmadi (Top 12 by date)