I have a function that compares each row in a database table with its relevant entry in the relevant file. When comparison is done its send back the results to client(browser window). If the count of rows to compare is smaller smaller like 200, its works fine, but when count is greater the comparison take time sometimes 4 or 5 minutes depending upon the rows to compare.
View 1 Replies
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 "|".
developing an application or simple script in asp.net which basically checks the md5 checksum of a file which will be my web application, and i want it to be compared with the original and be able to alert me of any changes ie defacement.
View 3 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 RepliesThe website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
there are 5 records in xml and next set of 5 records to be inserted in a same xml using asp.net , but xml is a single file
whether we have to use batch files ?
What is the preferred way to handle this? Delegates? I have a dropdown box of comparison operators = <, <=, > , >=, == which is used to set up a filter. The filter expression is exactly the same for every case other than the operator. I can do it through a switch, but I am sure there is a one liner that can handle to entire problem. Just not sure what it is?
case <
If a < b
case > [code]....
I need to know one Comparisons in CSV like this...
These are the columns in CSV 1 and CSV 2 :
Dekking id; Dekking; Acnv_id; Acnv description; From ; To; Value
Sample From CSV 1 Data :
Columns 1
499; Algemene Contractspecificaties; 122; Periodiciteit; 15/01/16; 15/01/16; 48
Columns 2
500; Opbouw Pensioenreserve; 130; Premietaks Tak 24; 15/01/16; 15/06/32; 29
Sample From CSV 2 Data :
Columns 1499; Algemene Contractspecificaties; 122; Commerciële; 08/01/16; 08/06/32; 12
Columns 2
500; Opbouw Pensioenreserve; 130; Waarborg 23; 08/01/16; 08/06/32; 29
I need to know how to compare these two columns from the column "Acnv description;" to "Value" as mostly the values from "Dekking id" to "Acnv_id" would be mostly common.
How to compare the values sepately FROM "Acnv description;" to "Value" Columns values IF the Columns "Dekking id; Dekking; Acnv_id;" MATCHES.
Dekking id; Dekking; Acnv_id; Acnv description; From ; To; Value
How to compare only these columns in the CSV ...
I am having 3 textboxes where I am inserting 3 employee names.I want to insert these details into database as 3 different records.Pls respond me ASAP
View 7 RepliesI have a aspx page where i have connected to a database using MS Access. I want to display total number of records in the products table & number of records the product Table holds inside.
View 2 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 want to insert multiple rows of data from a gridview to database table in a single button click event.
View 1 Replies I use grid view to show my data
when there isn't any data in data base it doesn't show grid view I want if there isn't any data in database it just show Grid view header.
i'm making a application for a newslettersystem. The only thing i want yet is to subscribe to a elecronic newsletter, but the record to subscribe isn't inserting. What do i do wrong?
[Code]....
and the vb code
Protected Sub btn_verwerken(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strConnectie As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("~/App_Data/nieuwsbrief.mdb")
Dim Connectie As New OleDbConnection(strConnectie)
Try
Connectie.Open()
Dim strSQL As String = "INSERT INTO TBL_Subscribers(Email, SubscribeDate, ActivateDate, UnsubscribeDate) VALUES (@Email, @SubscribeDate, @ActivateDate, @UnsubscribeDate)"
Dim command As New OleDbCommand(strSQL, Connectie)
command.Parameters.AddWithValue("@Email", Emailadres.Text)
command.Parameters.AddWithValue("@SubscribeDate", DateTime.Now)
command.ExecuteNonQuery()
Connectie.Close()
Response.Write("inserted")
Catch ex As Exception
MsgBox(ex.Message.ToString, MsgBoxStyle.Exclamation, "BCT")
End Try
End Sub
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 Repliesi 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've a function named fillgrid() which fills the grid with data.This function works correctly on pageload,but after inserting into database i've called this function again, which is not getting executed.This issue happens only in real time server not in my local system,I'm not getting any error and i cannot recognize why fillgrid() function is not getting called??I've used update panel.This is the code for insert function which inserts over 500records.
DataTable dtMob = new DataTable();
dtMob = dtMobilizn.Copy();
DataSet dsMobilizn=new DataSet("dsMobilization");
[code]....
I 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 don't want to use any asp.control to bind data so.
Is it possible to create dynamically customized table for database record.
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 have 5 link buttons in my asp page, i want to change the text property of the each of the link button to the data retrieved from my database table in th page load. To be more specific i want to display 5 latest film news headings in my home page and if the user clicks on a particular news heading i want to show that news details in a separate page with all the details related to that news.
View 1 Replies
