I am an ASP Noob. I have been tasked to create a primitive page that has 10 text fields that need to be submitted into a Sql Datbase when the submit button is clicked. Does anyone have a How to that can get me going down the right path.
View 11 Replies
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI 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 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've created a very simple database and added it to my project. i've added a Linq to SQL model and i even got the select and update commands to work nicley.
the problem is that i can't seem to insert new data to my data base.
[Code]....
now when i try to do a db.customer.Add i just don't get the Add in the intellisense.
I am new in ASP.Net MVC and facing problam to insert data into database.I am using LINQ to SQL(test.dbml) and Model1.edmx
My controller code is bellow
Function Index() As ActionResult
Dim db = New dbTestEntities() ' dbTest is my database
Dim testtable = New dbtestTable()
Dim mytest = New testDataContext()
testtable.Customer_ID = 3
testtable.Company = ""
testtable.First_Name = ""
testtable.Last_Name = ""
db.AddToTestTable(testtable) 'TestTable is my database table
db.SaveChanges()
Return View(testadd)
End Function
This code show ERROR Invalid column name
I'd like to insert data from excel to ms sql server.
I have success to read the data from excel by using dataset, but i don't know who to insert all data into database.
[Code]....
I am trying to insert null in a database column depending on a gridview datakeys value (if being "" insert null into database)However, I am getting a space ' ' inside the database column.
string sbcId = gvTest.DataKeys[gr.RowIndex]["myColumn"].ToString();
insgnp.Parameters.Add(new OleDbParameter("EMPID", (sbcId==""?DBNull.Value.ToString():sbcId)));
I am having a problem getting the FormView Control in Visual Studio 2010 inserting data into a SQL database I have managed to view the data that is currently in the database but when I click insert I get an error message I just don't understand what I am doing wrong
View 1 RepliesI am having a little problem with inserting selected items in a Checkboxlist into a SQL Database using C#.
Basically I have got a little checkboxlist that is populated form the database, when at least one of these items has been selected and you hit the Update button I want the aspx.cs btnUpdateItem_Click event to fire of a check which items have been selected and insert/update these into a database.
The approach I am taking is a foreach loop iterating through each item to see if it has been selected and then check if this record already exists in the database, if yes update it, if no create a new record. (The update and insert should be done by calling a stored procedure)
[Code]....
In the below code, when we define the parameters CommandName="Insert" is it actually the same as executing the method Insert? As I can't find Insert anywhere...
<div class="actionbuttons">
<Club:RolloverButton ID="apply1" CommandName="Insert" Text="Add Event" runat="server" />
<Club:RolloverLink ID="Cancel" Text="Cancel" runat="server" NavigateURL='<%# "Events_view.aspx?EventID=" + Convert.ToString(Eval("ID")) %>' />
</div>
I have the following SqlDataSource as well:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ClubSiteDB %>"
SelectCommand="SELECT dbo.Events.id, dbo.Events.starttime, dbo.events.endtime, dbo.Events.title, dbo.Events.description, dbo.Events.staticURL, dbo.Events.photo, dbo.Events.location, dbo.Locations.title AS locationname FROM dbo.Events LEFT OUTER JOIN dbo.Locations ON dbo.Events.location = dbo.Locations.id where Events.id=@id"
InsertCommand="INSERT INTO Events(starttime, endtime, title, description, staticURL, location, photo) VALUES (@starttime, @endtime, @title, @description, @staticURL, @location, @photo)"
UpdateCommand="UPDATE Events SET starttime = @starttime, endtime=@endtime, title = @title, description = @description, staticURL = @staticURL, location = @location, photo = @photo WHERE (id = @id)"
DeleteCommand="DELETE Events WHERE id=@id" OldValuesParameterFormatString="{0}">
<SelectParameters>
<asp:QueryStringParameter Name="id" QueryStringField="ID" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="starttime" Type="DateTime" />
<asp:Parameter Name="endtime" Type="DateTime" />
<asp:Parameter Name="title" />
<asp:Parameter Name="description" />
<asp:Parameter Name="staticURL" />
<asp:Parameter Name="location" />
<asp:Parameter Name="photo" />
<asp:Parameter Name="id" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="starttime" Type="DateTime" />
<asp:Parameter Name="endtime" Type="DateTime" />
<asp:Parameter Name="title" />
<asp:Parameter Name="description" />
<asp:Parameter Name="staticURL" />
<asp:Parameter Name="location" />
<asp:Parameter Name="photo" />
<asp:Parameter Name="id" />
</InsertParameters>
<DeleteParameters>
<asp:QueryStringParameter Name="id" QueryStringField="ID" />
</DeleteParameters>
</asp:SqlDataSource>
I want it to insert using the InsertCommand, however when I do SqlDataSource1.Insert() it's complaining that starttime is NULL
I want to insert textarea value into database as when user press enter in textarea that pertucular value before pressing enter btn should be insert in one row.
For example, if I wrote in textarea in this format
Monika,
Ritu,
Archana
Then in database it should enter as:
Monika in one row
Ritu in second row
Archana in thid row
The textarea i have used is
<asp:TextBox ID="TextBox2" runat="server" TextMode="MultiLine"></asp:TextBox>
How do you insert an object into a database, here is the object from the class:
public static Int32 InsertBaseCar(BaseCar theCar)
{
Int32 newBCarId = 0;
try
{
SqlConnection cn = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand("sp_InsertBaseCar", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", theCar.ID);
cmd.Parameters.AddWithValue("@make", theCar.Make);
cmd.Parameters.AddWithValue("@model", theCar.Model);
using (cn)
{
cn.Open();
newBCarId = Convert.ToInt32(cmd.ExecuteScalar());
}
}
catch
{
// write code here.
}
return newBCarId;
}
And here is my attend at inserting the code into the database:
public void InsertBaseCar()
{
BaseCar theCar = new BaseCar();
theCar.ID = Convert.ToInt32(txtBId.Text.Trim());
theCar.Make = txtBMake.Text.ToString();
theCar.Model = txtBModel.Text.ToString();
//InsertBaseCar();
txtBId.Text = string.Empty;
txtMake.Text = string.Empty;
txtModel.Text = string.Empty;
}
Not sure if this should be in SQL or .NET but as I'm doing this in asp.net I figured here..I'm trying to insert '00' into a varchar column of my database, when I do this its actually in the database as '0'... if I do '05' or '15' or '30' then its fine.
View 5 Repliesi have a Tag Table TagId TagName
Post Table PostId PostName
TagPost Table TagId PostId
How can i do a many to many insert into database in one transaction?
i am trying to use MySQL 5 and asp.net 4
i succeed withe the linking and display the data from MySQL DB but the problem is within the DML Commands !!
[Code]....
insert in gridview without saving data in Database?
View 1 Repliesafter i create the login page, i m used the login tool and set the role from the ASP.net configuration. Then, inside my project have aspnetdb already, i m asking that m i need to add another database to insert another information or just create new table inside the aspnetdb?
View 2 Repliesi have used Ado.net entity framework...how to insert an image to a table and retrieve it an show it.
View 21 RepliesI read data from Excel sheet and I display this data in grid view the problem when I save this data the asp.net tell me that this page contain dangerous code I want solution to this problem but I don't want to enable EnableEventValidation for security reasons.
View 1 RepliesI have TBL_PRODUCT table : ProductID, ProductName, CategoryID, Image. I can insert data to table :
[Code]....
I can upload image file too
[Code]....
But I want two function become one. When I press <Submit>, it's insert data and upload image file.
how i can insert image in SQL database?
View 8 RepliesUsing MVC 2 and VS 2010 RC.I have a varchar database column set to NOT NULL and I use the Entity Framework to bind the column to a textbox. I want a user to be able to leave the textbox blank and have an empty string inserted into the database column. However, MVC is trying to set the property to null during the Create postback, which causes ModelState.IsValid to be false and subsequently the validation UI is triggered with the message "The value '' is invalid".Here is the model:
[Code]....
The controller:
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Create(Candidate c )
{
if (ModelState.IsValid) // This is false when the textbox is left blank.
[code]...
I want to insert uploaded image in root directory images folder and its path to image column in database.
I am using the following code. It inserts the path to images in the database column, but not the filename:
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
On Error Resume Next
If FileUpload1.HasFile Then
FileUpload1.SaveAs(IO.Path.Combine(Server.MapPath("images"), FileUpload1.FileName))
End If
'/// upload images
Dim con As New SqlConnection
Dim cmd As New SqlCommand
con.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"
con.Open()
cmd.Connection = con
cmd.CommandText = "INSERT INTO Table3 (city, hotel, location, avialiability, room, price, image, category, from1, to1, price1, from2, to2, price2, from3, to3, price3, details) VALUES('" & Trim(DropDownList1.SelectedItem.Text) & "','" & Trim(DropDownList2.SelectedItem.Text) & "','" & Trim(TextBox5.Text) & "','" & Trim(TextBox6.Text) & "','" & Trim(DropDownList3.SelectedItem.Text) & "','" & Trim(TextBox7.Text) & "','" & "images/" & FileUpload1.FileName & "','" & Trim(TextBox17.Text) & "','" & Trim(TextBox8.Text) & "','" & Trim(TextBox9.Text) & "','" & Trim(TextBox10.Text) & "','" & Trim(TextBox11.Text) & "','" & Trim(TextBox12.Text) & "','" & Trim(TextBox13.Text) & "','" & Trim(TextBox14.Text) & "','" & Trim(TextBox15.Text) & "','" & Trim(TextBox16.Text) & "','" & (Editor1.Content) & "')"
cmd.ExecuteNonQuery()
con.Close()
End Sub
