Comments by SREENATH GANGA (Top 70 by date)

No only option is using the Date itself. We want to show the Expense and Income of each date
there is relationship between theese tables

which database

Thanks bro . I accept the Security issue and the chance that the answers will be available to users...but this is just a Kids project and doesn't require more security thats why i choose this option

thanks bro

14, 15 and 12th column means duration ,difference and difference1

yes its in the same folder and when I view it from local machine(development machine its working fine means page is navigates

I changed It and tried but still the issue is continuing

is it a windows app or web ?

good but if else may be little bit faster also check for null value when handling with dropdownlist

old system is windows 2000 now the new systems are Win& and win xp

I had the old system with me.can you pls tell me how to set up the Odbc datasource

but i had already developed more than 80 forms in winform using mdiparent child format

I am doing the same but the issue still remain why cannot we tell the application not to run unless the both the server time and client time are not synchroonized

@orginal grif you mean to say that i have to change all the insert query and replace all system.datetime.now.date to getdate() or any other a tips at server end

:) sorry @naveen

My appologies too.. Iam not a good webdeveloper this is my first webpage and iam a windows form developer till now so my html may be little bit messy

@naveen Default button doesnot require an focus to trigger ..anyway iam going to do the js for the meanwhile but this is a issue..and one more thing webform textbox doesnot have an keydown or keypress event

@naveen Soory if i confused you

Please look on the issue

Scenario 1: I entered the drivername on the textbox and cliked on the default button.......I get the datatable filled
Scenario 2 : I entered the drivername on the textbox and without leaving the focus from the textbox I press enter .....I didnt get any datatable filled

<asp:Panel Id="panel2" runat="server" DefaultButton="bt1">
<asp:TextBox ID="txtDrivername" runat="server" Width="153px">
<asp:Button id="bt1" Text="Default" runat="server" onclick="bt1_Click" />


it is bt1_Click itself

no @naveen my select query is working perfectly my issue is that when i press enter in the textbox the default button click event is not being triggered

@naveeen Query is returning value, when I physically click the defaultbutton it gives the datatable filled but when I type in the drivername and press enter that block is not executed

@sanjeev when iam clicking the default button its working and iam able to get a datatable filled ...but with enter button iam not able to get that same module run

i will set that datatable dt as the datasource of a gridview but the problem is this this query blow in not being executed.

i updated my question pls see it

means all is fine but when i press the enter key in debug mode it never enters the function bt1_Click() which is the click function of the default button

no.sorry

Thankyou for your support I kept the dropdownlist inside contenttemplate still issue continues

thank you ....but vwhen i try to put it inside iam getting error at run at server Parser Error Message: Type 'System.Web.UI.UpdatePanel' does not have a public property named 'DropDownList'.

hy script manager is at masterpage

wow great idea dear...let me try

Its 100s of controlssover there .........

thsnks Iam a new bie and is not so good in Stored procedures so to reduce learning time i chose inline queries

I was also wondering whether to use a datetime or Time ,,but I didnt want the date part t also to go to database ,this is the flace where i define the Shift time it doesnot need a date it just says shift A is from this time to this thime evaery day ..I will be using this time for every swipe in machine ...anyway was a good idea forwarded by you

thank you

is slno a feild from database

I tried it but same result

but the same resullt

yes

I had deleted .suo files but cannot find any.ncb or .user files and Iam not geting properties for controlls added in new forms also

no its not working my friend

sure if its only 2 seconds no prblm sir

THANK YOU A LOT

ya sir I know I have to get my own ideas I did it like this I created a autogenerating feild in database which get generated and incremented when i press the key "new jobcode" anf then I concatenate it to a string "NFT" so that the combination becomes NFT223 next one NFT224 etc but the thing is two data transaction is going on when i start creating jobcode (entering the database and finding last autoincremented value taking it to the application again) and again after data entry we have to submit back it will slow down athe application in future I think ANY WAAY THANK YOU FOR GUIDING

thank you sir but the problem is I want the alphanumeric value same for all and sorry tell that it is a little bit dificult in understanding ur answer as \iam a beginer can you explain simply plssss

thankuu it worked

sorry sir Iam new in codeproject anyway thank you for advice

can anyone tell me simply

can it be run on web like applet in java? sir sorry if iam asking foolishness

thank you it solved my problem very very thankssssssssssssss

thank you thanku a lotttttttttttt

I had done it but same exception occurs

the problm is not being corrected

I had already done it

dt contains 3 rows but it is not being filled on data grid

NO FRIEND THIS SOLUTION IS NOT WORKING

OleDbConnection oleDbConnection1 = new System.Data.OleDb.OleDbConnection(connString);
oleDbConnection1.Open();
String query = "Update masterusertable set username='" + userdata.Username + "',password='" + userdata.Passsword + "',phoneno=" + userdata.Phone + ", adress='" + userdata.Adress1 + "' where userid ='" + userdata.Userid + "'";


OleDbCommand oleDbCommand1 = new System.Data.OleDb.OleDbCommand(query, oleDbConnection1);
oleDbCommand1.CommandType = CommandType.Text;

oleDbCommand1.ExecuteNonQuery();

oleDbConnection1.Close();
showdata12();
clearcontrol();

this was my code
error it points to
oleDbCommand1.ExecuteNonQuery();

its shows oledbexception due to syntax error in update statement ,no the userid is text but unique NON DUPLICABLE

ya it also works tanku

the first snippet compiles without exception but give empty dataset
the second one show error that the Shipmentdate parameter doesnot exist in cureent contrast when i removed the quates it accept it but returns empty dataset Anyway Thanks for help

i had tried all and the above code shows no error but dataset is null the datatype of shipmentdate is date/time in shortdateformat in acess

at da adapter.fill()

type mismatch criteria exception

DateTime time = dtpfromDate.Value;
String timedsate = time.ToShortDateString();
MessageBox.Show(time.ToString());
OleDbConnection oledbconnection=new OleDbConnection(connString);
oledbconnection.Open();
String query = "Select jobcode,companyName,vehicleno,shipmentdate,totalamount,advance,drivername,fromPlace,destination from jobmastertable where (shipmentdate=@shipmentdate)";
OleDbDataAdapter dAdapter = new OleDbDataAdapter(query,oledbconnection);
dAdapter.SelectCommand.Parameters.AddWithValue("@shipmentdate", time);

DataSet ds = new DataSet();
dAdapter.Fill(ds,"tbljobmastertable");
tblpaymentview.DataSource = ds.Tables["tbljobmastertable"].DefaultView;

this worked without exception but no output