I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?
View 3 RepliesI want to insert multiple rows of data from a gridview to database table in a single button click event.
View 1 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?
I am doing update query to edit my records and save to my database...I am getting the query expression exception...syntax error (missing operator) in query expression 'WebLogin=krish'.
string strUserName = Request.QueryString["UserName"].ToString();
DateTime dateTimeNow = DateTime.Now;
string ConnString = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;[code]....
I am getting the exception syntax error (missing operator) in query expression 'WebLogin=krish'.
I am creating a asp page with database values.And I am showing in Gridview.in addition I need checkbox for each row. When I mark checkbox the row values to be stored in another table.
View 1 RepliesAs I am creating a asp page with database values.And I am showing in Gridview.in addition I need checkbox for each row. When I mark checkbox the row values to be stored in another table.
View 1 RepliesI have a test server link called http://en-test/application_report (this is just a sample example). The link is associated for when the application is placed on the test server
now if the application is placed on the production server, then it is[URL]. What i would like to do is to determine the link and if it is the test server then use the test database which is testdb and if it is the production server then use the production database which is proddb.
I have feedback panel where user can write HTML formated feedback using AJAX HTMLEditor I want to save this HTML DATA in SQL server HTML SOURCE
This is <span style="font-weight: bold; ">nice</span> question
HTML OUTPUT
This is nice question
Now how can i search to my database if your find "is nice" then my query can not response is nice because database contains HTML tags too. So what are best practices to save and retrieve HTML data using SQL Query & ASP.net.
I am trying to save html table to sql server table with unique name and save its data in a database. For example, I have a html table like this(it is dynamically created in browser by user).
I use asp.net, C#, Sql Server 2008 express.How can after clicking on save button, create table with unique name, 2 colums int and varchar(40) types, and insert data?
I think it is possible by rendering table to XML, and then work this xml on C# classes, then save in database.
What you sing about it?
[Code]....
I have a form with a bunch of checkboxes and textboxes. There will NOT be a "save" button on the page. What is the best way to save the work when data is entered in the textbox? I can do the checkboxes on a click changed event but how do I save data with the textboxes??
View 4 RepliesI can get my records from my database between days with this query.
[Code]....
but i need filter data between hours..
I have a table which stores records about a promotion programs. For each record, there are different status such as Begin, Successful, Unsucessful, Expired and there are PromotionDate and PromotionExpiredDate. I am just wondering how I can set each promotion to auto expired (auto change the status of each promotion status to Expired) when the current date is bigger than the PromotionExpiredDate.
View 4 RepliesMy team working asp.net File manage project. In our project we need to export database contents to csv formats
The Database table contains 6 fields. We are using LINQ.
how to save and retrive date in database using jquery ajex asp.net ,JSOn,XML
View 2 RepliesI have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesI have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
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.
Im working on a little hobby project. I already have written the code to get a url, download the header and return the mime type / content type.However, the step before this is the one im stuck on - i need to retrieve the contents of all the urls on the page based inside a tag, and in quotes i.e.
...
<link rel='shortcut icon' href="/static/favicon.ico" type="image/x-icon" />
...
Would find the favicon link.Is there anything helpful in the .net library or is this going to have to be a case for regex?
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 "|".
i believe That Saving Files In DataBase is good for Security Issue , But in My Scenario i didnt Care about Secrurity Issue,
i want to ask U guys which Better Save Files into DataBase or save it on Directory on Server, where This Issue Required:
1-(Reduce Load on Server and didnt affect server Memory).
2- Security not important.
if they have the same result i will move to DataBase Saving.
I have a data entry and editing form and in every data entry or update event, I have to send an email to a dynamic list of recipients. I have been sending the email as soon as the user clicks the save or edit buttons but am thinking of first saving the data to the database, and then sending the email later. I want to do this partly to improve the response time of the application as the email sending tends to take a long time than desired.
View 4 RepliesI want to save binary information like images, files ,etc to SQL server database.
View 1 RepliesMy company purchased ActivePDF WebGrabber a couple of years ago to convert a classic ASP created HTML page into a PDF form. The only drawback with the tool that we continually run into is that the outputted HTML links are not hot. Are there any tools that do include hot-links within the HTML to PDF output?
According to the ActivePDF FAQ for Does WebGrabber convert hyperlinks into usable links in the output PDF?, the answer is no. There is a phrase confusing me at the end of the answer:
"To implement links in the final PDF, the application would search for links prior to the Postscript generation, and append them once the PDF has been generated using Toolkit."
Does that mean this is how to achieve it, or is this their theoretical but not tested solution? If this is the solution, has anyone done this that might be able to post some sample (pseudo-)code?
Edit: I should mention that we're open to a different tool, and we need it to be accessible via classic ASP and ASP.NET. I would prefer a solution in which the links are automatically hot-linked during PDF generation.
I am trying to get the hotfile's downloadable file links in html source in
C#.Net.
Ex Html Source:
<A class="l" onmousedown="return clk(this.href,'','','','6','','0CDgQFjAF')"href="http://tinypaste.com/f4472e">
<EM>http://hotfile.com/dl</EM>/31214236/e3ad3a3/dora_ve_unicorn.avi.html<B>
.</B></A></H3><DIV class="s"><EM>http://hotfile.com/dl</EM>/31214236/e3ad3a
3/dora_ve_unicorn.avi.html <EM>http</EM><B>...</B><BR><SPAN class="f">
<CITE>tinypaste.com/f4472e</CITE>....
i just want to get "http://hotfile.com/dl</EM>/31214236/e3ad3a3/dora_ve_
unicorn.avi.html"link and that kind links from the whole Html source.
I tried to use Regex but couldnt find the correct exp.
I am Generating a Word Document by using Following Code:
StringBuilder str1HTMLContent = new StringBuilder();
str1HTMLContent.Append("<html>".ToString());
str1HTMLContent.Append("<body>".ToString()); [code]....
The word file is Created and popup on windows .How can i save this created word Document on Database, or on server folder?