i write program in asp.net that this program connect to database frequency and database has very records, i search about solution that i connect to database for one time and another time i use this information and when table records was updated , my program connect to database twice...(for example my program connect to database one time and later when only records was updated ,connect to database...)
View 1 RepliesI have a problem regarding database. I write to the database fine with this code:
[Code]....
When I close the application and view the Database with access.. the records are added ok, but when I start the application the records are deleted. This is what I have in the Form_Load:
[Code]....
I 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 "|".
in my system folder(E:\santhu) i have flat files(.txt and .doc ) .my problem is how to read those files automatically one by one and store the data(records) in to database?
View 8 RepliesI am facing problem..how to read Excel file from the 5th row onwards and how to store the all records into Database Note: More over i do want store few coloumns records(3 out 8) only in my database. consider this point.
View 4 RepliesI have a simple web form with controls such as test boxes, radio buttons, etc. I also have an empty SQL database created from within Visual Studio Express 2010, in the same project. I want to be able to open the web form, enter text, for example, in a text box, and have it saved in the corresponding field in the database. Ditto with the choice I make from a Radio List box, etc. Is there a simple way of connecting a control on a form with a field in the SQL database? I've tried a number of ways but can't seem to do it, though I realise it must be simple. I also think the control need to be in data entry mode, if there is such a thing, rather than automatically looking for data within the database to display (there is none). I'm new to SQL server and ASP.NET in general, though I've been through a lot of the excellent video tutorials etc.
View 8 Replies 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]....
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?
I want to show my database records in circle. If i use grid view or data grid or datalist then records will show in table structure. I want to show dynamic records in circle not as like forum view.
View 9 Repliesprotected void Button1_Click(object sender, EventArgs e)
View 3 RepliesPlease try to guide me how to achieve this one. my application need to do reading the PDF document and want to store the values in Database.Actually what happens is my customers sends me the OCR scanned copied in the form of PDF file. i need to read those scanned pdf files and store the customer information into my table.
View 1 RepliesI have created a page with a gridview in asp.net that displays the records of a database table and allows users to delete checked records by clicking on a delete button. After I delete a record and I try to refresh the page from the browser (I am using mozilla)I get the follow message:
"To display this page, Firefox must send information that will repeat any action (such as a search or order confirmation) that was performed earlier."
and if I click resend another record is deleted automatically. Even though I am reloading the gridview after the deletion the application executes again the onclick event of the delete button is executed and the gridview things that there is a checkedbox selected so the code executes my delete function again.
Is there any way to get rid of these behavior. I have been trying quit a few things but nothing works for me.
I have a database, one field is named "clicked" with values 0 or 1.
When the gridview is displayed I would like to show the value from the field "clicked" to be displayed as an image (example: instead of 0 to display and for 1 to display)
Is it possible?
Is there an easy way to search all the columns in the database?
I was the user to input a search word in a textbox and then search all of my database. I then want an array full of the primary keys of all of the records that had the search word contained somewhere in the record (i.e in any of the record fields).
This sounds really simple to me but I can't figure out how to do this and can't find examples online.
I want to add controls (or simply texts) to a ListView inside the ItemTemplate at run time.
The reason is that in my application I don't know in advance how many controls (or texts) I should insert.
For example I have to read the fields from a database table and insert in the ItemTemplate controls according to those fields:
<ItemTemplate>
<%# Eval("fieldname1")%> - <%# Eval("fieldname2")%> - <%# Eval("fieldname3")%> - .....
Afterwards I have to bind the ListView to the table content, so I need to preserve the <%# ... %> structure for the binding
I need to check for duplicate records before inserting them into the SQL database.Thus I have the following codes:
For count = 0 To GridView1.Rows.Count
If (GridView1.Rows(count).DataItem("Student Name").Equals(dtDataTable.Rows(count).Item("Student ID"))) Then
lblMsg.Text = "Records Existed"
End If
but there are error message. "Object variable or With block variable not set."
I have Mysql database.In that some records status is New.now,I bind database table to Listview(asp) control.
What's my problem is,the New status records(from Mysql database) text in Listview(after binding) is visible in
bold format.
I want to add dropdownlist in gridview n connet it to one of my database column how can i?
View 1 RepliesI have my repeater loading in plain text from a database right now e.g.
<td>
<a href="<%# DataBinder.Eval(Container.DataItem, "URL")%>">
<img alt="<%# DataBinder.Eval(Container.DataItem, "AltTag_Thumbnail")%>" src="<%# DataBinder.Eval(Container.DataItem, "URL_Thumbnail")%>" />
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Name") %>
</td>
My plain texts are image links and pdf URLs from a database table, in groups, in the correct order but I'm not sure how to render them correctly (sample image below shows what I am trying to render)
Is there any way to make a repeater template intelligent enough to render an "image link" OR "pdf link" based off the [type] column returned in the record?
table:
pk
Name
Type (image or pdf)
URL
Description
URL_Thumbnail (if image)
GroupId (associate these records to each other)
OrderNumber (order of these records within their GroupId)
i am trying to read data of from a sql database
the code that im using is as follows:
[Code]....
as you can see, im using table adapters - though when i run the page, it throughs me the following error, which i'm finding hard to understand
for my last project, i had to use the exact code, but at the time, i was using an access DB and now i'm uning sql D|B
the only difference from last time is that instead of using :
using System.Data.OleDb;
Now im using: using System.Data.SqlClient; //sql server
[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
i have a question regarding grid view. i have done almost all work i needed. but one thing i want to do is i have set 4 of page size of grid. so when i show records on the web page i want to set a iframe after first two records then iframe and then two more records like i have shown in the example image. i have used LINQ with C#.how to do it. if you people want i can show you my code.
View 3 RepliesI m uploading a text file. I want to read that text file line by line and I want to save that data into database if there are no errors in that text file. I have 5 different columns in database and I want to take those 5 columns data in the text file and insert into respective columns.
For this, which is the best way to do. Can we read and insert data into respective fields in no time.
How to bind records in charts through jquery in asp.net
cone, pie and bar
How do I insert records into database using Ajax editor.
View 1 Replies