I am unable to insert records into the database due to this error:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object
This sentence is highlighted in red:
osdb.Insert_ItemsRecords(txtID.Text, txtItemName.Text, txtItemDesc.Text);
BindGrid(true);
How do i set set the osdb to a valid instance?
currently I am doing a web application project using 3-tier formating to do out the project. In the grid view is displayed with data retrieved from the database and at the footer there is a row of empty fields for the user to insert records into database and when user clicks on Add New, a new row of empty fields will be populated below.
The database.cs and stored procedure is used to stored the data into the database.
[Code]....
This is the stored procedure code:
[Code]....
I am not sure of how to code out for the business logic?
I code this in business logic but its wrong as the error states the Insert method could not be found:
[code]....
How do I insert records into database using Ajax editor.Â
View 1 RepliesI am trying to implement this ..[URL]I have created stored procedure which is working fine. I have changed the database and table name.
In code behind I changed string query = "[GetCustomersPageWise]"; to===> string query = "[GetMsgs]" /*
Which is the correct name of my new stored procedure
*/In repeater code IÂ changed <b><u><span class="name">Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
<%# Eval("ContactName") %></span></u></b>
to ===> <b><u><span class="name">
<%# Eval("Date") %></span></u></b> /*and so on.
Date is a column name of the table i am using.*/
[Code]....
this is my html code
[Code]....
this is my code behind
[Code]....
this is my bal code
acuttally
in my javascript popup i am getting the checked values but i need it in record by record in the lblsave data
How to add checked records in nested gridview to database in ASP.Net?
View 1 RepliesI have 2 table in database
1-Estate_free Table
2-Black_list Table
in Register.aspx users can insert their information and when click on insertButton it insert their data into Estate_free table
below is code
 protected void insertButton_Click1(object sender, ImageClickEventArgs e)
{
SqlCommand _cmd = new SqlCommand("InsertFreeState1", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code].....
in above SP I define that if users tell or Mobile number was in Estate_free ro Black_list table it doesn't insert data into database and show 'You can just register 1 Time' and if there wasn't their mobile or Tell in those table it insert their data into Estate_free table and show 'You have been registered'.
problem is that when I enter data in database with new mobile number it didn't insert data in database and show 'you can just register 1 Time'.
I mean it never insert data in database.
what should i do?
I have Gridview on my webapplication and it is getting filled with multiple rows . When clicked on Save I want to Insert all rows without calling multiple database hits.
Is there any way I can insert all rows by single db hit?
i am using an ImageButton with onClick Event above a profile on a footballer.
On Click event, a logged in user on the site can save the footballer to a Junction table called FavouriteFootballer that has
a GUID UserId and FootballerId GUID as Primary Keys.
The problems is I need to warn the user if they already have the Footballer Stored as a favourite in the database
(With a Label or MessageBox PopUp) and not sure how to with the code I have.
In code behind I have the following
[code]....
I am trying to insert some records using objectdatasource but getting no result.
I am sure I have to write some code in insertbutton but what I am not getting to it.
Here is my code used:
[Code]....
Name
Product
section of job
Quantity
Max Quantity
A
ABC
offset print
100
1000
B
ABC
water base
200
1000
C
ABC
offset print
950
1000
How to insert multiple records like above at once, and how to manage quantity user input is not over max quantity. In example above: Max quantity of Offset printing is 1000 (bind from database, visible=false)
Woker A does Offset printing with quantity 100, C does Offset printing also but with quantity 950, if we sum quantity A and C do will be over 1000 Ã message box: warning
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI am having a list of contents in the notepad.
I having the following content.
000012|vasanth|Sofware Engineer|Chennai|
0000215|Arun|ASE|Keral|
The field is static and the column name is ID,name,Designation,City.
I need to read the note pad charecter by charecter and i have to insert the records corresponding in the field which is seperated by "|".
I've been wracking my brains for a while. I have a master record that I want to add children to. In a database it's a one to many relationship with a foreign key in the child table.
I have a formview that I want to use to fill in all the master record info, and choose the child info from a dropdownlist, and click an add button, and have the add button add the child info to some control on a page. Then when the user clicks insert, the formview has an ItemInserting EventHandler that will handle all the logic for inserting the master, grabbing its primary Key.
So, I know what to do, I'm just not sure of what control to use, or what memory object etc., that I want to store the child info in until the master record gets created.
I'm sure this has been done a million times, but for all my searching, I couldn't find anything to help me. Does anybody have some advice or can anybody point me to an internet resource where this has been hashed out?
I am inserting the records in Database thru asp.net??One of the columns is unique, I want that suppose the user inserted the same value once,control goes to catch block, I wnat to show my own error message ,only if unique index is same ,Rest for the other exceptions,it thrown by .Net?/
View 11 Repliescurrently I am doing an online store project using an example from one of your tutorials. In the grid view is populated with data and at the below of the grid view, there is a row of empty fields populated below. After user have enter all the necessary info and clicks on the Add New link, the data will be inserted into the database and it will also be displayed in the grid view itself. The software that I am using is called: MS VS 2008 C# The database that I am using is called: MS SQL Server 2008 This is the database.cs for inserting records into the database:
Code:
public bool Insert_ItemsRecords(string id, string itemName, string itemDesc)
{
SqlCommand cmd_ItemsList = new SqlCommand();
cmd_ItemsList.CommandText = "[VRM].[INSERT_ItemsRecords]";
cmd_ItemsList.CommandType = CommandType.StoredProcedure;
cmd_ItemsList.Parameters.Clear();
SqlParameter sqlParaID = new SqlParameter("@id", SqlDbType.VarChar, 10);
sqlParaID.Value = id;
cmd_ItemsList.Parameters.Add(sqlParaID);
SqlParameter sqlParaItemName = new SqlParameter("@itemName", SqlDbType.VarChar, 100);
sqlParaItemName.Value = itemName;
cmd_ItemsList.Parameters.Add(sqlParaItemName);
SqlParameter sqlParaItemDesc = new SqlParameter("@itemDesc", SqlDbType.VarChar, 1000);
sqlParaItemDesc.Value = itemDesc;
cmd_ItemsList.Parameters.Add(sqlParaItemDesc);
return executeNotQuery(cmd_ItemsList);
}
This is the stored procedure:
Code:
ALTER PROCEDURE [OS].[INSERT_ItemsRecords]
@id varchar(10),
@itemName varchar(100),
@itemDesc varchar(1000) .................
i want to insert some html code like
<html><body>jhguyegjh<?body></html>
but it is not inserting
I have 2 tables in SqlServer 2008.
Table1: T1id, SomeData
Table2: T2id, T1id, SomeData
I am using DataAdapter.FillSchema to create shema of tables in DataSet. I created DataRelation on columns
T1id in both tables.
Now when i try to Update Sql Database T1id in Table2 remains 0 and not the value of T1id in Table1.
I can successfully update Sql Database if i fill DataSet with records first (Using DataAdapter.Fill), but that's not what i want to do. I don't need "old" records in my dataset. I want to use dataset just to store all imputs from user until the proccess is done and then insert all those records "at the same time".
i have one xml blank file in my project .. i want to insert data from text boxes... my xml structure like
<?xml version="1.0" encoding="utf-8" ?>
<userdata>
<Project_name id="">
<datasource></datasource>
<database></database>
<server></server>
</Project_name>
</userdata>
project_name should be like Primary Key.. how can insert data through code
Conseptually what I'm doing is simple, and technically it may even be simple, but I'm still rusty. Here's what I'm trying to do:
I have a webform that allows the user to enter a new record, and in there I have also included a couple FileUpload controls. Upon clicking the "Save" button, I'm saving the details entered into one table (ITEMS), and also inserting the FileUpload details (path, id, upload_user) into another table ATTACHMNTS). Because one ITEM can have many attachments, I needed to split the tables up. So on save, I need to save the ITEM, save the ATTACHMENT, and then also put the ITEM_ID in the ATTACHMENT table. I'm second guessing myself because I think all I'd have to do is after I do the ITEM insert, do a SELECT MAX on the ITEM table and hold the newest (MAX) id in a variable and then use it in the ATTACHMENTS update. I'm not 100% on this because there IS a chance that someone else could save a few milliseconds later and I'll link the wrong ITEM. See my delima?
I am using link button in updatepanel and click on asp:linkbutton it refereshes all page. to stop _dopostback on link button click.or any alternative to use linkbutton.
View 1 RepliesI have a form wilh couple of Drop downs and text boxes and a Data Grid View which displays data from Access Table. When I hit add button on the form, I can see the data being added to the Grid View. But when I close the form and open the Access Database File (.mdb), the respective table is empty. The Access Table is not being updated. Second time if I open the form, the Grid View is also empty.I am pasting my code here.
Public Class Home
Shared OleDbConnection As System.Data.OleDb.OleDbConnection
Shared ExpensesDataAdapter As System.Data.OleDb.OleDbDataAdapter [code]....
I want to do bulk insert,bulk edit,multiple delete records in gridview.
View 1 RepliesI have this code :-
[Code]....
But the result is it only insert the first row of the HQDS dataset...then it will give this error :"Violation of PRIMARY KEY constraint 'PK_BRANCH'. Cannot insert duplicate key in object dbo.TS_BRANCH'.The statement has been terminated.
If I comment this line : Destadapter.Fill(HQds, "Testresult")
It doesn't give any error and also it doesn't insert anything to the database.
Violation of PRIMARY KEY constraint 'PK_TS_BRANCH'. Cannot insert duplicate key in object 'dbo.TS_BRANCH'.
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?