I would like get some hints reagding my application. Acctually I have a text file which is on Server and updated daily. After I parsed my text file, I would like to update my database according to the text file's data. I'm wondering how I can sepcify the input to SqlCommand so that my table should have the text file's input and then update the values.
View 8 Replies
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 Repliesi had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
View 2 RepliesSo my application is on a production and running smoothly with no bugs at all. yay! My question: Is there's more efficient way of updating an existing ASP.NET application? Here's what i'm currently doing ( dont laugh that's why im asking xD):
1. I compile the project,
2. after compilation i transfer the compiled files via ftp. then i delete the existing files on my folder and put the newer one.
I have to update a gridview inside an updatepanel in a button click.The thing is i'm having gridview in contentpage.I have placed scriptmanager in masterpage.when i clicked on the button to trigger the updatepanel,no update is happening in gridview.Moreover,after placing updatepanel control in contentpage,i saw a redcurvedline (which is an error basically) below the updatepanel control's text which is showing an error as "Element 'updatepanel' is not known element.This can occur if there is a compilation error in the website" in .aspx page's source view.I have attached the screen shot here of that page here for your reference.
But it's working in ordinary web page.
I am using gridview with update panel Animation extender for updating effects. Everything is working fine but when page expires(means session ends) and I try to uupdate(edit,delete record) it fadeout the grid but donot fadein and shows following javascript error as image. I want if session ends it should redirect to login instead of fading out and showing javascript error message
View 5 RepliesI want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
As I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.
Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.
Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?
I'm building a browers-based game that will need to constantly be updating EVERYONE'S accounts regularly; what is the best way to go about doing this? Creating a process that runs every time someone goes to a page on my site slows down the load time immensely. Do I need to create a windows scheduled task that calls this/these process(es)? It will need to constantly run.
View 2 RepliesBasically I have a site where I want the user to input something, have it go to the server for processing and then return it asynchronously, load the contents into a div and then fade it in with jQuery. What is the best way to the do accomplish this?
Currently here is my "solution":
$(document).ready(function () {
$('#output-box').hide();
$('#form1').submit(function () {
$.ajax({
type: "POST",
url: "Default.aspx/ParseData",
data: "{ $('#txtInput').val() }",
success: function (msg) {
$('#output-box').text(msg).fadeIn();
}
});
return false;
});
});
It doesn't work - just returns the contents of Default.aspx. So how do I properly send the contents of #txtInput to the ParseData function in Default.aspx.vb? Also, is this the best way to accomplish something like this? Should I even need to use jQuery to send the data, or should I simply call the function and have it grab the data server-side, put in the information in the result div, and then show it using jQuery?
I'm quite new to MVC, and only now i got hands-on with Ajax and Jquery as well.I've been reading a lot on blogs and forums, but can't seem to find the exact answer to my question.Here's what i want to do:1) Simple file manager View, where user can upload the file2) After successfully uploading, user is redirected to other View3) Meanwhile, the server starts processing the info existing on the file just uploaded. I want to be able to update the View the user is viewing, with the actions that are being performed on the server. Example (like stages): Reading File, Converting File, Parsing File, etc...4) When all stages are completed, i can show the user some buttons or whatever (until then, he has access to nothing...just view the page changing and processing)So....First, is this feasible?If so, how?I tried many approaches with AsyncController but can't seem to achieve nothing good.
View 1 RepliesI am asp.net developer and I work with SQL Server 2005 .
I have a table with 4 columns
say
Name
RollNo
Std
Div
if client enters
Name
RollNo
Std
but doesn't enters 4.Div column data and try's to save data, it should not give error, it should save the data in database
I tried to make an Update Panel to not load the whole page every time I need to load data from the Database server so I add Update Panel and add this java script code in every content page in my web site.
Code:
<script language="javascript" type="text/javascript">
<!--
with( Sys.WebForms.PageRequestManager.getInstance() )
[code]...
It works good but after end of the request I got a popup message say "NaN" every time I don't know from where it comes and of course it looks very bad for the client if got this popup.
I m getting following error in my eventvwr . I couldnt find reasons of the following error.
"Transaction (Process ID 110) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
The only thing my page is doing is inserting/updating data into a table in sql and the thing I can think of is because multiple users are using the same page to insert/update data? Will that cause deadlock?
i am using rich text box controal how to store rich text data in sql 2005
View 10 RepliesI am creating a website that reads and writes from SQL Server 2005.
I am able to write to the database but I can't retrieve that data and display it in a label.
how to retrieve the data and display it in a label.
The Dumps data are in the Excel file. Now I want o upload the data to sql server 2005(which are in web server) from client pc (from browser). What will be the best way to do so?
I can know how to upload data from excel to sql server 2005 if both are in the same computer.
i have a string like "13-9-10" i want to insert this as date into sql server 2005 in to a coumn "custdate" as type as datetime i added a sql paramater like this
Private Sub demoinsert(ByVal arr_data() As String)
DbCmd.CommandText = "INSERT INTO TBL_enqloan(cusdate) VALUES(@cusdate,)"
With DbCmd.Parameters
.Add("", SqlDbType.Date).Value=Convert.ToDateTime("arr(0).tostring")
end sub
getting an convert error how can i do it?
how to import data from sql server 2005 to Microsoft Excel in ASP.net with C# ?
View 4 RepliesI have a datatable for which i'm defining a dataadapter. I'm specifying an updatecommand with sqlparameters for the dataadapter I set the updatecommand's parameters using the following overload:
[Code]....
The length 16 is used because this is the length of the field according to sql (the image datafield is a pointer of size 16) I noticed .Net is actually truncating the string because of the length i'm setting. An image of size 3kb will properly upload if we set the length field to be greater than 3kb The question I have is what is the proper value (or strategy) to use in order to set for the length field so that ALL images will properly update to the database, with each using the appropriate size.
I guess i could theoretically set the length to be maxint, but this seems sloppy. Looking at sqlparameter documentation i didnt see an 'unlimited' or 'default' length i could set, which would allow each update statement called to use the appropriate size for the data length for that row.
i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field how to do this using file uploader.
View 3 RepliesI have a web application (ASP.NET 3.5) that allows the users to upload their own excel sheet. This sheet contains information about items that needs to be inserted to SQL Server 2005.
I already have this functionality, however, it's very slow (it takes almost 20 minutes to finish the request). I need a better way to handle this problem.
The sheet contains information about an item. These properties will be inserted into multiple tables for example (Books, Authors, Titles ... etc ...).
What I'm currently doing is the following:
The user uploads the file. The application opens the file. Read each row and update the database accordingly.
I'm using Microsoft.Office.Interop.Excel
Edit: I'm working with 10.000+ rows per sheet.
I am using an sql server 2005.
I want to insert to my table a column of some date,like that the user can insert a text file.
how to do that?
and how can I make that the user can only insert an int of length 9 for id?
1)How to convert 64base string to binary in asp.net and store into sql server.
2)when i convert 64 base string into binary & try to store it into database then it has taken so much tiime to insert. The size of 64base string is 1.5MB. and when i converted to binary then the size is 11MB.so the best way to insert the binary data into sql server. The data type of column is varbinary(MAX).
3)How can i insert the varbinary data into sql server uisng asp.net?
I want to use Full SQL Server 2005 as a data store for my role provider. I installed the aspnetdb using the wizard. in my application I added the following connection string
<connectionStrings>
<clear/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
then I configured my role provider as follows:
<roleManager enabled="true">
<providers>
<clear/>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer"
applicationName="/MyApp"
type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
I create roles programmatically like this:
if (Roles.RoleExists("RoleName"))
Roles.CreateRole("RoleName");
but when I check my aspnetdb from the SQL management studio I found that the table aspnet_Roles has no records and that the roles where not inserted. so is there anything wrong with these steps or something missing ?
