Click here to Skip to main content
15,914,416 members
Home / Discussions / C#
   

C#

 
QuestionMachine Names on Network Pin
Greeky22-Sep-05 23:11
Greeky22-Sep-05 23:11 
AnswerRe: Machine Names on Network Pin
enjoycrack23-Sep-05 1:22
enjoycrack23-Sep-05 1:22 
QuestionWeb Link in RichTextBox Pin
Greeky22-Sep-05 22:31
Greeky22-Sep-05 22:31 
AnswerRe: Web Link in RichTextBox Pin
enjoycrack23-Sep-05 1:25
enjoycrack23-Sep-05 1:25 
QuestionStraming integer values Pin
Afief22-Sep-05 22:22
Afief22-Sep-05 22:22 
QuestionMultiple Q's, Answer as many as you like. Pin
Anthony Mushrow22-Sep-05 22:07
professionalAnthony Mushrow22-Sep-05 22:07 
AnswerRe: Multiple Q's, Answer as many as you like. Pin
Niklas Ulvinge23-Sep-05 0:45
Niklas Ulvinge23-Sep-05 0:45 
QuestionCREATING AND DELETING DATABSE IN C# .NET Pin
EKJDBA22-Sep-05 22:05
EKJDBA22-Sep-05 22:05 
i made the following stored procedure
CREATE procedure databasecreation (@a varchar(20))
AS
declare @strquery varchar(1000)
SET @strquery = 'create database '+@a+ ''
EXEC (@strquery)

ALTER procedure databasedeletion(@a varchar(20))
AS
declare @strquery varchar(1000)
SET @strquery = 'DROP database '+@a+ ''
EXEC (@strquery)

when executing it in front end C#
code;-
SqlConnection c = new SqlConnection("server=dbasvr03;uid=sa;pwd=sa;database=banking");
private void button1_Click(object sender, System.EventArgs e)
{
String databasename;
databasename =textBox1.Text;
c.Open();
SqlDataAdapter MyDataAdapter= new SqlDataAdapter("databasecreation ", c); MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MyDataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@a",
SqlDbType.VarChar,20));
MyDataAdapter.SelectCommand.Parameters["@a"].Value = databasename;
MyDataAdapter.SelectCommand.ExecuteNonQuery();
Console.WriteLine("DATABASE CREATED");
c.Close();
}
AT EXECUTION THE FOLLOWING ERROR COMES-
databasecreation error: identifier 'databasecreation' out of scope

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll




PLEASE GIVE A SOLUTION

AnswerRe: CREATING AND DELETING DATABSE IN C# .NET Pin
sreejith ss nair23-Sep-05 2:19
sreejith ss nair23-Sep-05 2:19 
Questiondatagrid invoke and tablestyles Pin
xrado22-Sep-05 21:53
xrado22-Sep-05 21:53 
AnswerRe: datagrid invoke and tablestyles Pin
sreejith ss nair23-Sep-05 2:22
sreejith ss nair23-Sep-05 2:22 
GeneralRe: datagrid invoke and tablestyles Pin
xrado23-Sep-05 7:34
xrado23-Sep-05 7:34 
GeneralRe: datagrid invoke and tablestyles Pin
sreejith ss nair25-Sep-05 17:31
sreejith ss nair25-Sep-05 17:31 
GeneralRe: datagrid invoke and tablestyles Pin
xrado25-Sep-05 20:50
xrado25-Sep-05 20:50 
Questioni need help to fix the histogram.plz Pin
davidcooler22-Sep-05 21:19
davidcooler22-Sep-05 21:19 
AnswerRe: i need help to fix the histogram.plz Pin
Stefan Troschuetz22-Sep-05 21:51
Stefan Troschuetz22-Sep-05 21:51 
QuestionEDITING AND UPDATING DATA IN DATAGRID Pin
EKJDBA22-Sep-05 21:12
EKJDBA22-Sep-05 21:12 
AnswerRe: EDITING AND UPDATING DATA IN DATAGRID Pin
enjoycrack22-Sep-05 21:24
enjoycrack22-Sep-05 21:24 
Questioncreating and deleting database in C# ASP.net Pin
EKJDBA22-Sep-05 20:08
EKJDBA22-Sep-05 20:08 
AnswerRe: creating and deleting database in C# ASP.net Pin
enjoycrack22-Sep-05 20:27
enjoycrack22-Sep-05 20:27 
QuestionCapture Ctrl+Alt+Del Event Pin
krishnakumar7522-Sep-05 19:37
krishnakumar7522-Sep-05 19:37 
AnswerRe: Capture Ctrl+Alt+Del Event Pin
Dave Kreskowiak23-Sep-05 2:28
mveDave Kreskowiak23-Sep-05 2:28 
GeneralRe: Capture Ctrl+Alt+Del Event Pin
Tomas Brennan24-Sep-05 4:48
Tomas Brennan24-Sep-05 4:48 
GeneralRe: Capture Ctrl+Alt+Del Event Pin
Dave Kreskowiak25-Sep-05 1:39
mveDave Kreskowiak25-Sep-05 1:39 
Questionchar [ ] to float? Pin
levi's22-Sep-05 19:05
levi's22-Sep-05 19:05 

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.