Click here to Skip to main content
15,895,142 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Problem Still Exists Pin
Christian Graus13-May-08 0:50
protectorChristian Graus13-May-08 0:50 
GeneralRe: Problem Still Exists Pin
Krazy Programmer13-May-08 1:23
Krazy Programmer13-May-08 1:23 
QuestionDatalist Images not displaying in firefox Pin
markymark8213-May-08 0:31
markymark8213-May-08 0:31 
AnswerRe: Datalist Images not displaying in firefox Pin
eyeseetee13-May-08 0:49
eyeseetee13-May-08 0:49 
GeneralRe: Datalist Images not displaying in firefox Pin
markymark8213-May-08 0:52
markymark8213-May-08 0:52 
AnswerRe: Datalist Images not displaying in firefox Pin
eyeseetee13-May-08 0:51
eyeseetee13-May-08 0:51 
GeneralRe: Datalist Images not displaying in firefox Pin
markymark8213-May-08 0:57
markymark8213-May-08 0:57 
Questiondoubt on.... IMPORTING excel to SQL server?? Pin
Karan_TN13-May-08 0:22
Karan_TN13-May-08 0:22 
i download the source file of "ImportExportCSV_src" from codeproject and run this coding to import my excel to sql server. its working fine. but the thing is, i have a description column and user will enter more than 2000 characters. when i m importing, only 255 characters are uploading to the database (i declared in database as nvarchar and length 3000). whats the problem? how to resolve it? - KARAN

coding :

DataColumnCollection tableColumns = dsCSV.Tables[0].Columns;
DataRowCollection tableRows = dsCSV.Tables[0].Rows;
OpenConnection();
foreach (DataRow row in tableRows)
{
primary_key = row.ItemArray[1].ToString();
string sqlinsert = "INSERT INTO " + strTableName + "(";
string sqlvalues = "VALUES (";

object[] rowItems = row.ItemArray;
int ctrColumn = 0;
foreach (DataColumn dc in tableColumns)
{

if (ctrColumn < tableColumns.Count)
sqlinsert += "[" + dc.ColumnName.ToString() + "]" + ",";
if (ctrColumn < tableColumns.Count)
sqlvalues += "'" + rowItems[ctrColumn].ToString().Replace("'", "''") + "',";

ctrColumn++;
}

sqlinsert = sqlinsert + sqlvalues;
cmd = new SqlCommand(sqlinsert, conn);
try
{
rowscreated += cmd.ExecuteNonQuery();
strreturn = rowscreated.ToString();
}
catch (SqlException ae)
{
textbox1.Text=ae.ToString();
}
cmd.Dispose();
}
CloseConnection();


the thing is, when i check the row value (row.ItemArray) it can hold only 255 characters. so i cant upload the full 2000 characters. how to proceed this? help me ! - KARAN
QuestionHow to hide js file in the project Pin
Amit.Amit.Amit...13-May-08 0:18
Amit.Amit.Amit...13-May-08 0:18 
AnswerRe: How to hide js file in the project Pin
Christian Graus13-May-08 0:21
protectorChristian Graus13-May-08 0:21 
GeneralRe: How to hide js file in the project Pin
Amit.Amit.Amit...13-May-08 0:33
Amit.Amit.Amit...13-May-08 0:33 
GeneralRe: How to hide js file in the project Pin
Christian Graus13-May-08 0:35
protectorChristian Graus13-May-08 0:35 
GeneralRe: How to hide js file in the project Pin
Amit.Amit.Amit...13-May-08 0:44
Amit.Amit.Amit...13-May-08 0:44 
GeneralRe: How to hide js file in the project Pin
Christian Graus13-May-08 0:48
protectorChristian Graus13-May-08 0:48 
GeneralRe: How to hide js file in the project Pin
Amit.Amit.Amit...13-May-08 0:55
Amit.Amit.Amit...13-May-08 0:55 
GeneralRe: How to hide js file in the project Pin
Amit.Amit.Amit...13-May-08 1:02
Amit.Amit.Amit...13-May-08 1:02 
GeneralRe: How to hide js file in the project Pin
Christian Graus13-May-08 1:20
protectorChristian Graus13-May-08 1:20 
GeneralRe: How to hide js file in the project Pin
Amit.Amit.Amit...13-May-08 1:39
Amit.Amit.Amit...13-May-08 1:39 
AnswerRe: How to hide js file in the project Pin
MHASSANF18-May-08 20:44
MHASSANF18-May-08 20:44 
QuestionConfirmation image generation Pin
Muhammad Gouda13-May-08 0:11
Muhammad Gouda13-May-08 0:11 
AnswerRe: Confirmation image generation Pin
Christian Graus13-May-08 0:17
protectorChristian Graus13-May-08 0:17 
GeneralRe: Confirmation image generation Pin
Muhammad Gouda13-May-08 0:30
Muhammad Gouda13-May-08 0:30 
GeneralRe: Confirmation image generation Pin
Christian Graus13-May-08 0:35
protectorChristian Graus13-May-08 0:35 
AnswerRe: Confirmation image generation Pin
Raviprakash R13-May-08 1:17
Raviprakash R13-May-08 1:17 
QuestionWhat port does rss feed go through Pin
eyeseetee12-May-08 23:55
eyeseetee12-May-08 23:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.