(int) faultsGroup is 0 or 1 but i always get this error: Column 'FaultGroup' cannot be null Does anyone tell me why? Syntax looks ok.
[Code]....
I'm writing a function in "Query Browser" to add some values to a table.
The function should get this value when the stored procedure is called upon, thus te code looks like:
INSERT INTO customer(customer_name, customer_city) VALUES (@customer_name, @customer_city);
But when trying to execute the function, it says "customer_name can't be null"
i thought maybe it just waiting for the values to be sent from .aspx page, but yet again, i get the same error message.
I am using VS 2010, C# and Sql server 2008. I am having a list returned from the database. I am trying to convert the
list to a dataset.
I am getting the error as "Cannot set column 'column name' to be null. use DBNull instead.
This is the code i have used:
[Code]....
How to fix this?
I have a table called category that has tow attribute (Cid,Name)
what can i do to insert category name only without allow user to insert category id in my webpage, I use view detail control and make the wizard link but when run the error message appear (Cannot insert the value NULL into column 'Cid)
note the identity properties is not pass.
I have two table with a one to many relation.
1- voteChoose has (Choid PK,Choose,Vid)
2-VoteQuestion has(Vid PK,Vquestion,Action)
so when insert a question and answer in a page this error message (
Cannot insert the value NULL into column 'Vid') appears
i use this function to add vote
public void AddVote(string VQuestion, string[] Choose)
I am LINQ querrying against a datatable. However, I am unsuccessfull with catching null values. Here is my code that is giving me the following error.
[Code]....
I am checking to see if minperc is null. However to check that it still is trying to convert the value to double. Cant figure out a way around it. Here is the error: Cannot cast DBNull.Value to type 'System.Double'. Please use a nullable type.
I have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
View 7 RepliesI have gridviwe having 2 columns:
1) DocNumber 2)Title
query select docnumber,title from tbl_docs.
BindwithGridviwe(sql);
Now the issue is that that every document doesn't has document number. I want to make invisible the docuNumber column of the grid viwe if all values in the docNumber retrieved are null.for example:
docnumber tite
null Document 1
null Document 2
null doucment 3
null document 4
if returned result match above where all docnumber are null then make the gridviwe docnumber column ivisible eslemake the greidviwe column visible.
I am trying to insert NULL value in oracle database using asp.net form. and its not inserting null value check my below code and guide me what changes I have make
Dim
cn As
New OracleConnection("Data
Source=ab; User Id=abc;Password=abc")
Dim SQL
As
String
'build the INSERT statement
Dim xy
As
New System.Text.StringBuilder
'Dim strDate As Date...............................
Using VS2008, c# and ODP.Net(2.111.7.20)
In the following procedure a_end_date may or may not be null.
If the input string is null, I tried to set a_end_date to null.
It is giving error.
The same result if I try to set it to dbNull.
How do I set null to a date field
public string InsertOnlineApplication(
string a_start_date,
string a_end_date,
[code]...
i dont know how to set the field to blank field instead of null
if i insert record, and don't input some field, then the field will display null
how to remove null value by default in mysql db.
I use VS2005 on Oracle 10gR2. Using
(System.ComponentModel.DataObjectMethodType.Update,
True) to update database row that returns null values from date and numeric columns,Whenever i try to update same row with null (or empty) values on both date and numeric columns, it results in sending '01-Jan-0001' for date column and 0 for numeric column. I want the user to have the options of null or corresponding values for the update.
m getting this error again and again. i m also using the ajax modalpopup extender in my page ..
View 3 RepliesMy site was woking fine, now i noticed that i get an error "Microsoft JScript runtime error: 'null' is null or not an object" when i checked the view source, i saw the following system generated code
<script type="text/javascript">
var Page_ValidationActive = false;
if (typeof(ValidatorOnLoad) == "function") {
ValidatorOnLoad();
function ValidatorOnSubmit() {
if (Page_ValidationActive) {
return ValidatorCommonOnSubmit();
}
else {
return true;
}
WebForm_AutoFocus('txtMailAddress');// --> IS THIS RIGHT???? out side the braces???
</script>
</form>
</body>
</HTML>
and a reference to this line below
<IFRAME id="__hifSmartNav" name="__hifSmartNav" style="display:none" src="/m2qa/WebResource.axd?d=fvL5WUdiCo1B4KvdiJfkfg2&t=633546432952161750"></IFRAME>
Using MySQL 5.
In my SAP.NEt project, defined a constant:
public static DateTime NullDateTime = DateTime.MinValue;
I have a function:
protected static DateTime GetDateTime(DataRow row, string columnName)
{
return (row[columnName] != DBNull.Value) ?
Convert.ToDateTime(row[columnName]) :
Globals.NullDateTime;
}
In the source code:
public DateTime StationFeedTime{ get; set; }
StationFeedTime = GetDateTime(row, "StationFeedTime");
I ran a SQL to fetch records from MySQL, this field is Time field in MySQL.
Got an exception inside the function:
Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.
I have a MySql function that i wrote in Query Broswer, that adds a new entry into the "customer" table.
The values are provided from an .aspx page, and after the insertion, the function should return "1" (int value). So, my .aspx page is:
[Code]....
I am developing web application using csharp and MS SQL as database. There is a column in table that is storing values which as numbers and letters. Letters are in front like JK26262, JK26263,JK26263.
Now I want to select numbers only from a table column and leave letters. In other words I want an select statement that will select values as follows:
26262
26263
26263
How can Iachieve this?
i have a question how to retrieve the row values as a column. please check the below tables i need the query for this table.
[Code]....
I'm getting a "no data exists for the row/column" error when i am giving wrong value in key column and press button to import data from excel,how can i fix this error and avoid collapsing the application.
[Code]....
I have read the excel in asp.net. I am using OledbDatareader for read the column name.
[Code]....
Now my problem is the "date" field. If Excel sheet having column name "Date" then i got the error. i could not use the Column index because its also not fix. How can i ignore the upper case charactors in column name ?
I am not able to understand what is the problem with My sql ..as same query is run sucessfully while i use SQL Server 2005 whit out any Exception or error.........
Select Count( Date ) From Attendancemaster
Error in SELECT clause: expression near ')'.
Unable to parse query text.
this is very simple query run sucessfully in SQL Server 2005 but not in
MY SQL and giving Error..and the query on which any datetime avar comes in WHERE clause allso generate error always....?
[Code]....
Cannot insert the value NULL into column?
I have an asp:BulletedList controls with AJAX:PagingBulletedListExtender on my aspx page.
It gives error as: Microsoft JScript runtime error: Sys.ArgumentException: Value must not be null for Controls and Behaviors. Parameter name: element
If I removed, the asp:BulletedList controls and AJAX:PagingBulletedListExtender from my page then page run without any error.
I am not getting the cause of the error.
I want to update multiple column of a table using subquery ...My sample code is shown below
[Code]....
its throwing syntax error...I dont know where i commiting mistake.
I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column.
View 1 Replies