I am new in asp.net..My Problem is i have 3 textboxes..
in first text box i enter A1,
Second Textbox i enter 3,
Third Textbox i enter 5
after button click i want to store
A1B1,A1B2,A1B3 as per second textbox i enter 3
A1C1,A1C2,A1C3,A1C4,A1C5 as per Third Textbox i enter 5
how to generate the above rows and how to save in database
I want to be able to select rows and save them for later display. I wish to store the data in a session object for viewing before i decide to save permanent in database.
View 4 Repliespublic void saveOptionalCourses( ArrayList coursesAdded, int studentID)
{
StudentOptionalCoursesXRef XRefObject = new StudentOptionalCoursesXRef();
using (var EntityObject = new SchoolProjectEntities2())
{
foreach ( string list in coursesAdded)
{
XRefObject.StudentDetails = EntityObject.StudentDetails.Where(c => c.StudentID == studentID).First();
XRefObject.OptionalCourses = EntityObject.OptionalCourses.Where(c => c.OptionalCourseName == list).FirstOrDefault();
EntityObject.AddToStudentOptionalCoursesXRef(XRefObject);
}
EntityObject.SaveChanges();
}
with this above method and could save only last row that am returning remaining rows are iterated but are not saving on to database
I'm using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a lot of records.
I'm having error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I need to save more than 20 rows at a time in database, i did it for previous requirement using a loop, provided rows were not exceeding 10.
Now i have rows exceeding more than 20 or 50, how can mass save operation be performed using asp.net web application.
I want to enter multiple contacts in a web form. That is..if a click on any "Add" button, it should display another textbox to enter, after it shold save multiple contacts to the database...
View 3 RepliesSave (Insert) values of multiple CheckBoxes to database in ASP.Net
View 1 RepliesI have check box field in grid view and I want to save checked row in sql server 2005.how i can save.
View 1 RepliesI have another problem is that I have Placed a file upload control in Empty template of Gridview to have multiple record insert. I have used viewstate to save multiple record into database. But problem is that I am able to find the control but it not giving any value.I have following code.
[Code]....
in above code
[Code]....
I have a text file.I need to get data from this text file and show on grid ,1)After this user can update information from gridview, 2)Click on save button save data on database.Before clicking on button data don't save on database.How to do that?
View 1 Replies[Code]....
Multiple upload and save to database..
I want to select many rows from my SQL Server database and combine them in a certain manner. Currently, I've been using the following method to get these rows:
[code]....
I am designing my database and wanted to know the best way to handle this problem. I have tabs on a page that looks like this:
Tab1
--SubTab1
----Data1
--SubTab1
--SubTab1
Tab2
--SubTab1
--SubTab1
--SubTab1
Tab3
--SubTab1
--SubTab1
--SubTab1
I can put this information in the database that will be stored in multiple rows like this
TypeID---------------Name
1--------------------Tab
2--------------------Data
ObjectID----------Parent-------------TypeID
1-----------------0------------------1
2-----------------0------------------1
3-----------------0------------------1
4-----------------1------------------1
Or I can just put this in the database like so:
<root>
<tab name="MyTab">
<tab name="MySubTab">
<data>1234567890</data>
</tab>
</tab>
</root>
If I pull just the xml from the database then I would not need to select multiple rows i just need to select one row then parse the xml into a class then pass that data to the controller. I just would like to know if this is a good idea? Will I be making a mistake if my site to scale in the future? Will this make more maintenance as the site gets bigger and want more features?
I have used Jquery Qucik serach Plugin and Its working fine for me. But I want to get the each record after filter when click on save button.
let's say gridview has total records are 4 then filtered records are 2.When click on Save button 4 records are getting.
I want to insert almost 400 rows in one database call in asp.net. I am using .net 3.5 and sql server 2005. What should be the best possible way for doing that?.
View 1 RepliesI've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
View 6 RepliesI have a save button outside the gridview and I want to save all the values/records of gridview at once or row by row in database(sql server) .
View 1 RepliesI have a save boutton outside the listview and i want to save all the value records of listview at once or row by row in databace (sql server).
View 1 RepliesI am having Fileupload control in my page where I can Upload 4 images maximum into how can I do it ...
View 1 Repliesdropdown list second value not save in sql but images save successfully.
<ajax:ToolkitScriptManager ID="toolkit1" runat="server"></ajax:ToolkitScriptManager>
<asp:DropDownList ID="dalbum" runat="server" ></asp:DropDownList>
<ajax:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif,bmp,doc,docx" OnUploadComplete="AjaxFileUpload1_UploadComplete1"/>
using System;
using System.Collections.Generic;
using System.Web;
[code]....
I want to save three images path in table also upload images in folder,how it is possible?[Using ajax file upload control]table columns are imagepath1,imagepath2,imagepath3. URL....
HTML
<asp:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif"
MaximumNumberOfFiles="3" OnUploadComplete="File_Upload"
Width="500px" />
C#
protected void File_Upload(object sender, AjaxFileUploadEventArgs e)
[code]....
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 need to produce a from where I can add multiple parts. Each time a user enters a part number, the description should be populated. The user can then click add and this part and description will be shown below. They have the option to add as many parts as they require. Once all parts are added the user fills in some general info eg description and then once a submit button is clicked all part info will be inserted into a table and general info will be inserted into another table with one unique ID.
View 5 Repliesi 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 want to add gridview row data into to data base I am doing it perfectly.My problem is that want all gridview row data save and then web method should be called but in my cause one gridview data save in array then call webmethod,then other row data save in array then call webmethod called this process should be so on.But I want it webmethod should be called when all gridview row save in array.
Follwing code
Jquery
<script type="text/javascript">
$(function () {
$("[id*=btnSubmit]").bind("click", function () {
var Customer = {};
[code]....