Comments by Ashwini Thakare (Top 25 by date)

protected void Submitbtn_Click(object sender, EventArgs e)
{



string connection_string = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HILProject\project4\App_Data\adminlog.mdb";
using (OleDbConnection cn = new OleDbConnection(connection_string))
{
cn.Open();


String str = "select Nationality, Post from BasicDtl_tbl where UserName=" + usertxt.Text;
OleDbCommand cmd = new OleDbCommand(str,cn);
// cmd.Connection = cn;
OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
System.Data.DataSet ds = new System.Data.DataSet();
try
{
ad.Fill(ds);

Nattxt.Text = ds.Tables[0].Rows[0].ItemArray[3].ToString();
apldposttxt.Text = ds.Tables[0].Rows[0].ItemArray[4].ToString();
cn.Close();

}
catch(Exception)
{
StatusLabel.Text = "error occured";
}
}
data does not get retrieved

what is this world_rep

i removed extra tag now i am getting error as "no value given for one or more required parameter"
actually basicdtl_tbl have 4 column as ID, UserName,Nationality, Post
i want to retrieve only values of Nationality and post and display it in respective textbox

i used addwith value and also added wtlang but then also it is showing same error

i tried this code but it is showing same error

[OleDbException (0x80040e14): Syntax error in UPDATE statement.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1070856
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +247
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +167
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
FillForm.activites() in c:\HILProject\project4\FillForm111.aspx.cs:1170
FillForm.Submitbtn_Click(Object sender, EventArgs e) in c:\HILProject\project4\FillForm111.aspx.cs:848
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

thank you

i tried this code but my image does not got saved in the database
i have image datatype as oleobject

but i have used oleobject as datatype of image in ms access database

insert two images in a particular row by using where username = textbox value
the table already have username filled in it

<asp:FileUpload ID="FileUploadControl1" runat="server" />
i want to save image in ms access database. image is stored as oleobject.
how to write update statement to insert image using where clause

thank you

i have already inserted username in the table now i just want to insert values from textbox into nationality and post column by matching username column value with value of usertxt textbox
my table basicdtl_tbl contains 3 columns i.e username, nationality, post

if i enter username value into a textbox displayed in fil form application
write a query to insert data into table by using where clause like the following code

command.CommandText = "insert into BasicDtl_tbl([Nationality],[Post]) values ('" + Nattxt.Text + "','" + apldposttxt.Text + "') WHERE UserName =usertxt.Text ";

is this the right way of writing a query

actually i m working on fill application form database where i want to save data in various tables but at the same time the data should get saved in proper row so i am using one common field username in every table. userreg table contains username field as primary key which will be used to access all tables.

username is a common field in both userreg and basicdtl_tbl. username field in userreg is primary key and username field in basicdtl_tbl is foriegn key

i want to update single username row in basicdtl_tbl by matching username column of both basicdtl_tbl and usereg table so that data will get update in proper username

thanks for your suggestion.
It worked.
thanks a lot

nbsp;      
<asp:DropDownList ID="Post_DDL" runat="server" AutoPostBack="True"
onselectedindexchanged="Post_DDL_SelectedIndexChanged">
<asp:ListItem Selected="True">Select post
<asp:ListItem>IT Person
<asp:ListItem>HR Person

   
<br />
<asp:RadioButton ID="RadioButtonMale" runat="server" Text="Male"
AutoPostBack="True" GroupName="genderrbt" oncheckedchanged="RadioButtongenderrbt_CheckedChanged"
/>
            <asp:RadioButton
ID="RadioButtonFemale" runat="server" Text="Female" AutoPostBack="True"
GroupName="genderrbt" oncheckedchanged="RadioButtongenderrbt_CheckedChanged" />
<br />


this is some section of my code. the page gets reloaded as i select any item

after trying this code i am getting following error

"The SMTP server requires a secure connection or the client was not authenticated. "