DataSource Controls :: Null Being Place In SQLdatabase Istead Of Information?
Jul 8, 2010
My sqldatabase is inputting NULL instead of the information from my form. Form is collecting different names and multiple phone numbers for each. names, addresses, zip codes are going in as entered on form but phone numbers are not they are going in as NULL. Columns are set as header is Cell, nvarchar, Length is 15 and I have setup as I did other columns. code for my form is (i have removed some lines that are working as expected)
i need the northwind databse. i dont have it in the database where i can find it and who to add it to my database in sql server so can i c it in the combo box off the database
I do my new website in Sqlserver2005,But when i upload it at that time DataBase Related page display Database error. In this site without Database page open. So give me reply I also add my database in hosting side How to attach my database in my asp.net website , when i upload this.
here is my code for selectiong some records from db table
string strSql = "select * from mtblNBD where SentTo=@SentTo and InternalStatus Is NULL order by DeadLine desc"; SqlCommand com = new SqlCommand(strSql, con); com.Parameters.Add("@SentTo", SqlDbType.NVarChar, 50).Value = (string)Session["uname"];
here I am using parameters for SenTo field but not for NULL so it is ok... or should I use parameters for this field where value is NULL , if yes then how can I use parameter for this
I have page that has a datasource. The datasource executes a stored procedure and returns results. If the result is NULL, I'd like to forward the user to an error page. How would I accomplish this with ASP.NET and C#?
I'm using SQL server 2005 and Visual Webdeveloper 2008 express.
I have a database created and I've successfully connected to it. My question is, would it be possible to do something like search the first column of a table for a value, get the index of that row and use the index to get the value of each column? Sort of like you would with an array.
Are there are good tutorials out there that I could use, everything I found shows you how to display your information in a datagrid, which I've already done, but I can't find anything on how to get an individual row's information.
How can I retrieve information from delete rows. I delete some rows from table in dataset, then I use method GetChanges(DataRowState.Deleted) to get deleted rows. I try delete rows in original table on server side, but it finished with this errors. I try get value of columns from row, which was deleted [Code]....
It's probably something small but I can't seem to find what went wrong. I am trying to insert information into my database. It goes through the code just find but it doesn't insert into my database. Here's my code:
I have a C#/Asp.net web application which caches SQL DB schema information. Is there a way that I can determine what child relationships a given table has? I have looked into using the DataTable.ChildRelations property, but it is never populated with items unless i manually create a relationship using the .add property. I also have access to DataColumn information for each column in the database.
Basically the main page has a couple of DataSourceObjects sucking information from a local database and displaying them on the page. The page is a form, which then generates an HTML email and fires it off using the SMTPClient. The problem is that I cannot seem to get the data from the database to be accessable from the code-behind. Attempting to get data from either of the ListViews results in a number of Null Exception errors, mainly when using the ExtractItemValues method. The OrderedDictionary that comes back always seems to be empty. So I figured I'd use one of the 3 Object Data Sources I already have set up, that queries the actual database, but cannot find any way of calling the Select statement present in either of them, let alone managing to store and access what comes back.
I have a website that displays information from my database into a gridview. The gridview has a checkbox, that once selected, is suppose to move a 'Y' into the field that has the checkbox selected. I have it generating the code, and displaying the code on my page to confirm, but the database is not being updated. Here is my code,
I need to enter text in sql in nvarchar(max) .. the text contains titles and paragraphs.
I was using a separate table called paragraphs to enter paragraph title and paragraph content. These get a 'article ID' so I can read them out of SQL. On my page I format title and content differently.
Now I was wondering if I can enter Title format information into sql (as the <br/>) tags, so that i can enter all article information into 1 table column.
I'm using Content Management System, DotNetNuke for my dynamic website. DNN itself they have one database, I named it dnnDB. Inside the dnnDB they have the users table which have the list of users. I need to be able to pull this set of information or synchronize to my own database, myDatabase for development purposes. I do not want to incorporate my database into dnnDB, afraid that I may corrupt the system.
I build a webpage to edit the data entry, all the textbox wroks fine. However when I update the value originally took in using dropdown list , I get error and couldn't get correct update.
I need to retrive a value from a column of a table per stored proc. This is usually an integer, but also can be null. I get this value and store it in a session variable.
Later, I need to pass this same session variable to another stored proc.
Session["myVariable"] = ds.tables[0].rows[0][1]; // this can be null or an integer
somewhere else in the project, I need to pass it to another stored proc exactly as received.