|
there are textboxes where i am entereing the int type value.here i am using sp to
save the value.if i am giving all the values in the textboxes the its working fine.but if i
am not giving all the values in the textbox means if i left some textbox with giving any value
.then its showing error as:" Message="Conversion from string " to type 'Integer' is not valid.".
where i have written the code as" cmd.Parameters.Add("@no_mp_record", Data.SqlDbType.Int)
cmd.Parameters("@no_mp_record").Value = CType(TxtBxMp.Text, Int32) "
and in the database i have defined its value as null and also in storeprocedure i have done accaordingly.
i have executed the sp seperately n its working.
why i am getting the error. or what will be solution for the error
|
|
|
|
|
check the textbox for null valuue
if(!Convert.IsDBNull(txtCodeDesc.Value)
{
cmd.Parameters("@no_mp_record").Value = CType(TxtBxMp.Text, Int32);
}
winnie
|
|
|
|
|
hai what is that "txtCodeDesc"
|
|
|
|
|
hey just remove that and put this ...
TxtBxMp
winnie
|
|
|
|
|
what will be its corresponding vb code
|
|
|
|
|
IF Not IsDBNull(TxtBxMp.Text) Then
cmd.Parameters("@no_mp_record").Value = CType(TxtBxMp.Text, Int32)
End If
winnie
|
|
|
|
|
Hello Everyone,
Hi i've designed a web page(Contact Form) in ASP.NET 1.1 and this form looking great in Internet Explorer but looking very different in Mozilla
As....
I've to take Telephone in three different text boxes as Country Code,Area Code and Telephone No.....
and I set Textbox for "Country Code" width= 40 px;
and also for "Area Code" width=40 px
and Telephone=100 px
Mozilla's taking three textboxes of the same width =100 px
and plz let me know how to set the width and color or other designing for displaying the textbox or other controls same as on Internet Explorer
|
|
|
|
|
even i have faced this problem , the cssis not supporting Mozilla browser, we gave our client to use IE 5.5 +
any suggestions on the above will be good
winnie
|
|
|
|
|
I too faced the same problem.
Then i took the whole page into a table and set width, height, length, etc.
If i need to design in different tables, i used instead of Table inside a table and set its width, etc...
Try this, u will get the result
|
|
|
|
|
i have gridview which is populating data from emp table.
where the columns of emp table are
empid int,emp_name varchar(20),emp_sex char(1).
in the gridview i have assigned the autogeneratedselect coloumn as true.so when ever i am populating data from the database the select option is shown for every row.
now i want to dispaly the emp_id of the record (in another textbox say textbox2)to which i have selected. what wil be code in vb.net for it.i mean to say if i have selected the record whose emp_id is 2 then this emp_id should be displayed in the textbox2..
|
|
|
|
|
Hi,
I am designing a form with a DataGrid and other server controls, TextBox, Calendar, ListBox etc. The idea is at page load the grid would be filled, when user clicks a row in the grid, the controls below would be filled with data in the grid so that user may edit data and submit again.
However, everytime I click a row, the validators in the conrols below are firing. Say, one textbox is not filled by data from Grid, but it has a custom validator, it will fire when user clicks a row. Its annoying because this form has lots of controls with validators and the moment I click the row in Grid, lots of required field and custom validator errors would fill the validator summary.
Could anyone suggest how to avoid this?
Regards,
Blumen
|
|
|
|
|
set the "CausesValidation" property of that control to false
Regards
John
|
|
|
|
|
cant set the causesvalidation to false because validators has to fire when data is entered in those controls and Submit button is clicked, but not when a row in the grid is clicked.
|
|
|
|
|
what is that server control(child control) used to click the item in the grid?
change the "causesvalidation" property of that child control. keep the causesvalidation property of the submit button the same. Let the validation happen when you submit the page, not when you fetch the data during postback.
Regards
John
|
|
|
|
|
I'm directly clicking on the grid rows, not any child controls. The grid has a hidden cloumn, which has a unique id. This id is unique for every row. I'm using this id on row click and getting data from the database, with data I fill the controls below the Grid.
So this is the scenario. What can I do now?
Regards,
Blumen
|
|
|
|
|
try this ValidateRequest=false in your page directive of your asp.net page,, but there are security concerns
winnie
|
|
|
|
|
Page validation should not be turned OFF when there is a need to validate the data on submit.
To disable validation for any control on the page, need to set the control's CausesValidation property to false
Regards
John
|
|
|
|
|
Hi,
I have a problem. How do you send xml file (or data in xml file or in string) from one aspx page to other aspx page. Remember that the other aspx page is different application. we can't use context here.
The content of the xml is more to accomodate through Query String. Can some body help me
Thanks in advance
Naren
Naren
|
|
|
|
|
store the XML file into database and pass the ID in the query string and retrieve it from the database in the other aspx page...
Regards
John
|
|
|
|
|
No. We have to pass that one as string only. That application can be able to read the string through the query string only. that application is a III party application where we can't handle.
Thanks,
Naren
|
|
|
|
|
Store the XML either on Disk or Database and pass the 3rd party an ID to that XML. Then provide them with a WebService that accepts the ID and returns the correct XML. This way you can avoid trying to pass a huge XML document through the QueryString.
|
|
|
|
|
If the other page is a different application, then you're kind of stuck, the query string is your only hope.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i have a table named emp.
where one coloumn named "status",
which doesnot take any value from the front end.i am storing its default valus as"ON" in the emp table which is set in its cloumn property .
and another table emp_detail where one column named "eligible".( both tables are related with each other by "emp_id" coloumn)where it takes the value from the frontend either "Y" or "N".now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF.
where it takes the value from the frontend either "Y" or "N".
now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF.
|
|
|
|
|
you can change the status while inseting the data in emp_detail table. Or you can create a triger on emp_detail table on insert and check the eligible column and update emp table as per value
Hardik Panchal
|
|
|
|
|
i dont know how to write trigger.but know the storeprocedure,so can let me know howto write the trigger for that
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
