I have this code now but its complaining about the string not in a correct format


string lid = "";
//its conplaining about this line int loanid = int.Parse(lid)
int loanid = int.Parse(lid);
...

Here it goes,

I want to get(Select) values from the Database and bind them into Textboxes, then the user can edit them and update them that means writting them to the database again with the new...

I dont think I understand what ur trying to say can u elaborarte a bit,

Thanks

Hi all

I am trying to retrieve a data from Oracle database and display it in the textboxes to be editable but with no luck, am getting a ORA error, missing right parenthesis, that sounds easy and...

String sql = "Select * From Book Where Title = " + txtSearch.Text

I dont know why I didnt think about that, I guess it is true that inexperience programmers like complicating things

Thanks...

Hi all

I have a datagrid filled with data from Oracle database, I have a textbox and a button search and on the textbox a person/user can enter the Title of the book he/she wana search the the...

Well my code is in my laptop at home and at work w r using sql server whereas I used oracle for my project, coz I know in SQL is much easier than it is in Oracle, i could do it in SQL but in Oracle...

Yah ur right why I didnt think about that, I actually am, but I can write a code to edit and get the data from database what Im struggling to do is to make sure that the row is selected from the...

Its VS 2008, what I am doing is I am binding a table from Oracle to a datagrid and I wana be able to select/highlight a row from a datagrid and transfer the data from the selected row to another form...

And just how do u do that?

Hey Guys

I need to be able to select or hightlight datagrid row when a user place a mouse on certain record then, he/she can be able to click delete or edit button to delete the selected row or...

Hey, U r right ithelp it is really simple

Thanks guys

Does anyone know or have a source code for calculating Zodiac or Star sign using a given date of Birth

Thanks in Advance

No, The student can reserve a book which is on loan so to do that the student needs to login, otherwise they can browse for books without logging in, sometimes there are articles or journals which...

I dont think thats gona work coz this is gona be online website, so I will only have one login page for everyone coz there is gona be no way to determine who clicked the login button now between the...

I am designing a Library website, and I have two table Libarian and Student table so when the Libarian login should have access to all the database(Adding new record, updating and all) but when the...

Any Dot Net forum package I can get out there guys

Thanks

Thanx a lot

A user have to register to the site using Her existing email address as a user name so I need to send an email to the user's email address once her registration to my site is successful can anyone...

Hey Guys

I have 2 DropDownList, with country and Province so I select country from the DDL provinces belong to that country should be populated to the Province DDL but instead Im get an Error with...

Hey thanx it worked

I am developing a website and am struggling to make sure that even if my web page is minimized a user can still see the entire content of the page without maximising the page, I believe thats...

Is there any way to hide columns in the datagrid that are data bounded using C# coz I have realized that they are not references as columns maybe cells but then again I dont find visible property...

SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);

Try and fix this line cos you dont need to put the country_id within single and...

SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);

Why your country_ID which you declared as a string is within single and double...

I think at the moment u can use that to debug and see whats working and what's not working then after that u can fix ur selectedindexchanged event on DDL

U jst need to make sure that the countryID on the state table is corresponding to the one on the country name, then you can have a select stateme like this on ur dataadpater


Select * from State...

I had the same problem my DDL doesnt talk to me back if I just select and do nothing, I couldnt figure out what was the problem because I had selectedChanged event but then until I had a button which...

Is your DDL filled with each country?

My code is partial working cozI still have a problem coz when I select add to cart on my 1st datagrid it overwrite the existing record instead of adding to it but everything else is working

But...

Im not sure about ur error but usually causes of ur error are that
1. The file ur trying ti access its protection is set to read only
2. U actually do not have rights to access, execute or cahnge...

Yah sure if u open the connection u surely need to close it and the best way to close connection is to close it in a finally statement if u have try/catch statement or just after using it, it is not...

No I got the problem, those are actually the details of the error not my code, so thats not silly....

so the problem was that I was refering to the cell in my datagrid which was a...

That could be the problem, but then can you provide me with the code similar to that, coz Im clueless what ur talking about

Thanx hey

I have 2 datagrid, 1 with details of Category and the other with the products user selected from the other datagrid, what Im saying is I have a select command on my 1st datagrid so when I select...

I have the ff error and I have no idea what is

Line 1: Incorrect syntax near ','.
Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ','.

Source Error: ...

Thanx a lot man.... ur a star

Yes I added that on my code but still it doesnt work or show the details that falls under that category in the datagrid

I have all my categories loaded on my Dropdownlist but the problem is when I select a category the details of that category do not show on datagrid and I think the problem is on selectedIndexChanged...

Guys

I have a dropdownlist control with categories so when I select something from ddlCategory I wana display all the products fall under that category in a datagrid but I dont seem to get that...