Comments by Mr.VJ (Top 38 by date)

getting error near executenonquery.

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=phonebook.accdb");
OleDbCommand cmdd = new OleDbCommand();



cmdd = new OleDbCommand();
cmdd.CommandText = "INSERT into login([image],[imagename],[name],[username],[email],[password],[mobile],[gender],[dob],[question],[answer]) VALUES(@image,@imagename,@name,@username,@email,@password,@mobile,@gender,@dob,@question,@answer)";
cmdd.Connection = conn;

cmdd.Parameters.AddWithValue("@image", imgByteArr);
cmdd.Parameters.AddWithValue("@imagename", imgname);
cmdd.Parameters.AddWithValue("@name", textBoxname.Text);
cmdd.Parameters.AddWithValue("@username", textBoxuser.Text);
cmdd.Parameters.AddWithValue("@email", textBoxemail.Text);
cmdd.Parameters.AddWithValue("@password", textBoxretype.Text);
cmdd.Parameters.AddWithValue("@mobile", textBoxmobile.Text);
cmdd.Parameters.AddWithValue("@gender", radio);
cmdd.Parameters.AddWithValue("@dob", dat);
cmdd.Parameters.AddWithValue("@question", comboBox1.Text);
cmdd.Parameters.AddWithValue("@answer", textBoxanswer.Text);
conn.Open();
cmdd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("inserted sucessfully","confirmation");

MainWindow main = new MainWindow();
main.Show();
this.Close();

still getting the same error :(

thank u for reply Maciej Los

i did like this

cmdd = new OleDbCommand("select [date]='"+present date+"' from Remainder where [rusername]='" + loginusername + "' ", conn);
conn.Open();
cmdd.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter(cmdd);

//da .Fill(ds);
da.Fill(dt);

conn.Close();


string remdate = dt.Rows[0]["date"].ToString();//but here getting error like date column does belongs to table.

still getting same error


i tried this one ....

OleDbCommand cmdd = new OleDbCommand("SELECT addimage,addname,addnumber1 FROM addcontact", conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmdd);

da.Fill(ds);
if (ds != null)
{
view.Table = ds.Tables[0];
dataGrid1.DataContext = view;
view.RowFilter = "addname like '%" + SearchBox.Text + "%'";
dataGrid1.DataContext = view;
}
else
{
MessageBox.Show(" dataset having null value");
}

thank u jayant for replying , but getting an error by putting a DataView view = dt.DefaultView;

thank u so much murali , it helps me a lot

great work mohammad hossein .... it helps me a lot ,thank u :)

friends i have done this but getting an error : Null exception at dv.table=ds.table[0];

this code works fine in c# winform but not in Wpf .

please help me out.



public DataView dv
{
get;
set;
}

OleDbCommand cmdd = new OleDbCommand("SELECT addimage,addname,addnumber1 FROM addcontact", conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmdd);
DataTable dt = new DataTable();
da.Fill(ds);
dv.Table = ds.Tables[0];
dataGrid1.DataContext = dv;
dv.RowFilter = "addname like '%" + SearchBox.Text + "%'";
dataGrid1.DataContext = dv;

thank u ,

i tried ,but getting

EXCEPTION :

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

thank u ,

i tried ,but getting

EXCEPTION :

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

thank you bro.... it helps a lot :)

here getting an error as datatype mis match .. iam trying this one .please help me if u have any alternate solutions.


private void button1_Click(object sender, RoutedEventArgs e)
{
cmdd = new OleDbCommand();

string iname=Application.Current.Resources["iname"].ToString();

byte[] imagedata = File.ReadAllBytes(iname);


//var imageBuffer = BitmapSourceToByteArray((BitmapSource)image2.Source);
cmdd.CommandText = "INSERT into login([image],[imagename]) VALUES(@image,@imagename)";
cmdd.Connection = conn;
conn.Open();
OleDbParameter myParameter = new OleDbParameter("@image", OleDbType.LongVarBinary, imagedata.Length);

myParameter.Value = imagedata;

cmdd.Parameters.Add(myParameter);
//cmdd.Parameters.Add("@image", imageBuffer);
cmdd.Parameters.Add("@imagename", iname);
cmdd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("sucessfull");
}

im using mysql .... please tell me how to give logon

hey thank u so much , its so simple .

where should i click and option where not visible here .

thank u

thank u. please tell me how to do that.

here my requirement is , when ill save the textbox.text , this textbox.text message/text should display in sticky notes.

here my requirement is , when ill save the textbox.text , this textbox.text message/text should display in sticky notes.

hello virandra , here i getting an error
System.Drawing.Image fullSizeImg
= System.Drawing.Image.FromFile(path);

path cannot found but everything was ok.

dt.Rows.Add(new object[] {DateTime.Now});

here getting error

getting same error

thanks for reply , its not working.

thnq so much bro ;)

thnqqqqq so much :)

thanks for giving suggestion ,but after uploading a image should display the image.

yes , i used but image not displaying after i use fileupload.

hdn_imagepath.Value = "PH-" + Session["DQ_Doctor_ID"].ToString() + DateTime.Now.ToString("ddmmyy-hhmmss tt") + ".png";
Silverlight1.InitParameters = "PHOTO_NAME=" + hdn_imagepath.Value + ",DISPLAY_PHOTO=null";

in insert command i used hdn_imagepath.Value

Strings

here getting error in Strings.Format(Convert.ToDateTime(txtDate.Text), "dd/MM/yyyy");

it is Strings or anything else ?

thnku codestar007 , but i need to retrive the data from database.

hello , i need to send from website to mobile ex like way2sms.