Click here to Skip to main content
15,891,657 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: AJAX Help Pin
Christian Graus3-Jun-09 12:29
protectorChristian Graus3-Jun-09 12:29 
AnswerRe: AJAX Help Pin
dotnetmember3-Jun-09 19:24
dotnetmember3-Jun-09 19:24 
QuestionNeed programming help. Pin
har dh3-Jun-09 9:10
har dh3-Jun-09 9:10 
AnswerRe: Need programming help. Pin
Not Active3-Jun-09 10:06
mentorNot Active3-Jun-09 10:06 
AnswerRe: Need programming help. Pin
Manas Bhardwaj3-Jun-09 10:09
professionalManas Bhardwaj3-Jun-09 10:09 
AnswerRe: Need programming help. Pin
Christian Graus3-Jun-09 10:27
protectorChristian Graus3-Jun-09 10:27 
AnswerRe: Need programming help. Pin
Abhishek Sur3-Jun-09 12:06
professionalAbhishek Sur3-Jun-09 12:06 
Questionwhen using .mdb to upload files, it was good. but....in MSSQL.. Pin
lsh486love3-Jun-09 6:35
lsh486love3-Jun-09 6:35 
Originally, I declared to use mdb for uploading files like the following codes before changing.

//connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+
// MapPath("Files.mdb");


I declared like this for using to upload files to MSSQL :
connString = "Provider=SQLOLEDB;Data Source = db.incheonlaw.ac.kr; Initial Catalog=stanlee;User ID=stanlee;Password=stan;";

After changing codes, there is an error, Must declare the variable "@Writing_Num". when debuging this part, "cmd.ExecuteNonQuery();"........


using (OleDbConnection con = new OleDbConnection(ConnectionString))
using (OleDbCommand cmd = new OleDbCommand(CmdText, con))
{
OleDbParameterCollection pms = cmd.Parameters;

pms.Add("@Writing_Num", OleDbType.VarChar, 50);
pms.Add("@FileName", OleDbType.VarChar, 200);
pms.Add("@FileSize", OleDbType.Integer);
pms.Add("@ContentType", OleDbType.VarChar, 50);
pms.Add("@FileData", OleDbType.VarBinary);


pms["@Writing_Num"].Value = writing_num;
pms["@FileName"].Value = fileName;
pms["@FileSize"].Value = fileLength;
pms["@ContentType"].Value = contentType;
pms["@FileData"].Value = fileData;

pms = null;

con.Open();
cmd.ExecuteNonQuery();
}


How can I properly use mssql???

Is there something wrong??
AnswerRe: when using .mdb to upload files, it was good. but....in MSSQL.. Pin
Ennis Ray Lynch, Jr.3-Jun-09 8:08
Ennis Ray Lynch, Jr.3-Jun-09 8:08 
QuestionOracle Data reader with Crystal Report Viewer Pin
Girish4813-Jun-09 4:16
Girish4813-Jun-09 4:16 
AnswerRe: Oracle Data reader with Crystal Report Viewer Pin
David Mujica3-Jun-09 4:31
David Mujica3-Jun-09 4:31 
AnswerRe: Oracle Data reader with Crystal Report Viewer Pin
Ennis Ray Lynch, Jr.3-Jun-09 5:07
Ennis Ray Lynch, Jr.3-Jun-09 5:07 
GeneralRe: Oracle Data reader with Crystal Report Viewer Pin
Girish4813-Jun-09 5:17
Girish4813-Jun-09 5:17 
GeneralRe: Oracle Data reader with Crystal Report Viewer Pin
Ennis Ray Lynch, Jr.3-Jun-09 5:19
Ennis Ray Lynch, Jr.3-Jun-09 5:19 
GeneralRe: Oracle Data reader with Crystal Report Viewer Pin
Girish4813-Jun-09 5:23
Girish4813-Jun-09 5:23 
GeneralRe: Oracle Data reader with Crystal Report Viewer Pin
Ennis Ray Lynch, Jr.3-Jun-09 5:26
Ennis Ray Lynch, Jr.3-Jun-09 5:26 
GeneralRe: Oracle Data reader with Crystal Report Viewer Pin
Girish4813-Jun-09 5:32
Girish4813-Jun-09 5:32 
GeneralRe: Oracle Data reader with Crystal Report Viewer Pin
Girish4814-Jun-09 0:25
Girish4814-Jun-09 0:25 
QuestionWeb App Builder Pin
developer63-Jun-09 3:53
developer63-Jun-09 3:53 
AnswerRe: Web App Builder Pin
Manas Bhardwaj3-Jun-09 4:07
professionalManas Bhardwaj3-Jun-09 4:07 
AnswerRe: Web App Builder Pin
RichardGrimmer3-Jun-09 4:55
RichardGrimmer3-Jun-09 4:55 
GeneralRe: Web App Builder Pin
developer63-Jun-09 5:07
developer63-Jun-09 5:07 
GeneralRe: Web App Builder Pin
RichardGrimmer5-Jun-09 1:03
RichardGrimmer5-Jun-09 1:03 
QuestionDetermine the type of request? Pin
Matt Cavanagh3-Jun-09 3:47
Matt Cavanagh3-Jun-09 3:47 
AnswerRe: Determine the type of request? Pin
Ennis Ray Lynch, Jr.3-Jun-09 5:10
Ennis Ray Lynch, Jr.3-Jun-09 5:10 

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.