-
Hello.... Just curious about how to clear out any data that might be held in the browser during the following scenario: -User inputs a massive amount of data into a text box. -Contents of text box are moved into an SQL table -Gridview displays the data from table ( no prob so far ) -Now, if the user...
-
Hi there, I am doing an INSERT into a table. I have a "DateCreated" field and I have set the field to ALLOW NULLS = FALSE but set the default value to getdate() When I execute the stored procedure it tell me "SqlException: Cannot insert the value NULL into column "DateCreated"...
-
The code below works fine: SqlStr = "UPDATE recorddb SET " + Target + " =@Record WHERE day=@Date" SqlCom = New SqlCommand(SqlStr, SqlCon) SqlCom.Parameters.AddWithValue( "@Record" , record) SqlCom.Parameters.AddWithValue( "@Date" , today) Note: Target is a string...
-
i would like to ask how to sum each and every column in Grid View i've seen many posts on the web teaching how to sum a particular column. however, my GridView has some 40 columns. every column contains numbers which can be summed and there is no null value . is there a way which allows me to automatically...
-
I'm working on a form that is supposed to enter records into a table in an access db. While spitting out the results specific to the user, it only shows the first record. The Random Number part works perfectly, the insert statement works as well. It's the datalist that doesn't show up correctly...
-
Hi There, I have a table in the database stored in SQL with the following specifications: IMAGES_TBL(SNO, ID,IMG) SNO- INT IDENTITY(1,1) ID - INT (can repeat through the table) IMG - of datatype IMAGE ( not stored as url but in bytes) In my code i upload images for a particular ID. There is no issue...
-
I am not looking for specific code here, but more a general framework of how to tack this: I want to output e-mail messages to some users. But with the resources I am given I can only get names which are stored in our Active Directory (No there is no way I can just get the -mails). So I am querying a...
-
Hello everyone , I have an issue i.e, I am using crystal report(version 11 release 2) in my windows applications developed in vb.net (2005)and sql server(2005) as backend . In one of the forms i placed one reportviewer control, crystal report taking long time for preview & print(nearly 2 minute)...
-
// System.Globalization.CultureInfo TrCulture = new System.Globalization.CultureInfo("tr-TR"); public static SqlConnection sqlBaglanti = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Baglanti"]); public static void Sorgu_Calistir(string sql) { SqlCommand...
Posted to
Getting Started
(Forum)
by
ozel1
on
05-29-2009, 12:00 AM
Filed under: MS Access, SQL, as.net, connect asp.net website database, example, Sample Codes
-
I am trying to write a system which allows users to enter thier details in a form which is then submitted to the database which i have managed to do so far but now i want to be able to let the update the details that they have previously entered in the same form. I have a dataadapter which fills a dataset...