Click here to Skip to main content
15,895,142 members
Home / Discussions / C#
   

C#

 
AnswerRe: how to send sms using c#.net Pin
Luis Alonso Ramos26-Aug-05 16:27
Luis Alonso Ramos26-Aug-05 16:27 
AnswerRe: how to send sms using c#.net Pin
eggie526-Aug-05 7:07
eggie526-Aug-05 7:07 
GeneralRe: how to send sms using c#.net Pin
surfman1926-Aug-05 13:21
surfman1926-Aug-05 13:21 
GeneralRe: how to send sms using c#.net Pin
eggie526-Aug-05 13:41
eggie526-Aug-05 13:41 
GeneralRe: how to send sms using c#.net Pin
sajikp28-Aug-05 20:24
sajikp28-Aug-05 20:24 
GeneralRe: how to send sms using c#.net Pin
sajikp28-Aug-05 22:12
sajikp28-Aug-05 22:12 
GeneralRe: how to send sms using c#.net Pin
eggie526-Aug-05 13:50
eggie526-Aug-05 13:50 
QuestionProblem with C# and Stored procedure Pin
kbalias25-Aug-05 21:34
kbalias25-Aug-05 21:34 
Hi
I want to run a stored procedure to load records from the database into a dataset. It gives me message that the stored procedure requires a parameter @ProdIndex which is not supplied. I have debugged my code and I cannot see what the problem is. Some of the code is as follows (all my stored procedures that require parameters, are giving me similar messages):

public class ProductManager
{
public ProductManager()
{
}

public static DataSet LoadProductsSProc(int prodIndex)
{
//sproc is the Stored Procedure name
//IS THERE A BETTER WAY THAN HARD-CODING IT HERE
string sproc = "Select_Products_ProdID";

//create two-dimensional array of objects to hold the parameter name and value
//IS THERE A BETTER WAY OF DOING THIS?
object[,] parameters = new object[1,2];
parameters[0,0] = "ProdIndex";
parameters[0,1] = prodIndex;

DataSet ds = GeneralDAL.LoadObjectsDS(sproc, parameters);
return ds;
}
}



public class GeneralDAL
{

public static DataSet LoadObjectsDS(string sprocedure, object[,] parameters)
{
DataSet ds = null;

SqlConnection conn = null;

try
{
//instantiate the conn object – this works fine
conn = new SqlConnection(“database”,”server”);
conn.Open();

//create a SqlCommand object
SqlCommand sqlCmd = new SqlCommand(sprocedure, conn);
sqlCmd.CommandType = CommandType.StoredProcedure;

//add the parameters to the SqlCommand object
for (int i=0; i
AnswerRe: Problem with C# and Stored procedure Pin
jdkulkarni26-Aug-05 0:13
jdkulkarni26-Aug-05 0:13 
GeneralRe: Problem with C# and Stored procedure Pin
Not Active26-Aug-05 3:15
mentorNot Active26-Aug-05 3:15 
AnswerRe: Problem with C# and Stored procedure Pin
Guffa26-Aug-05 9:58
Guffa26-Aug-05 9:58 
QuestionCreating Simply Audio File Pin
allenmpcx25-Aug-05 20:36
allenmpcx25-Aug-05 20:36 
AnswerRe: Creating Simply Audio File Pin
gnjunge25-Aug-05 23:46
gnjunge25-Aug-05 23:46 
GeneralRe: Creating Simply Audio File Pin
radic.feng26-Aug-05 0:58
radic.feng26-Aug-05 0:58 
Questionhow to save files in non windows application using c# Pin
sajikp25-Aug-05 20:30
sajikp25-Aug-05 20:30 
AnswerRe: how to save files in non windows application using c# Pin
Dave Kreskowiak26-Aug-05 1:50
mveDave Kreskowiak26-Aug-05 1:50 
GeneralRe: how to save files in non windows application using c# Pin
sajikp28-Aug-05 22:02
sajikp28-Aug-05 22:02 
GeneralRe: how to save files in non windows application using c# Pin
Dave Kreskowiak29-Aug-05 1:32
mveDave Kreskowiak29-Aug-05 1:32 
QuestionRead Excel file properties. Pin
jdkulkarni25-Aug-05 19:56
jdkulkarni25-Aug-05 19:56 
AnswerRe: Read Excel file properties. Pin
jdkulkarni25-Aug-05 20:48
jdkulkarni25-Aug-05 20:48 
QuestionMeasuring Delay Pin
Cheezo25-Aug-05 18:34
Cheezo25-Aug-05 18:34 
AnswerRe: Measuring Delay Pin
Dave Kreskowiak26-Aug-05 5:25
mveDave Kreskowiak26-Aug-05 5:25 
GeneralRe: Measuring Delay Pin
Cheezo28-Aug-05 20:11
Cheezo28-Aug-05 20:11 
GeneralRe: Measuring Delay Pin
Dave Kreskowiak29-Aug-05 1:27
mveDave Kreskowiak29-Aug-05 1:27 
Question: Some tough software challenges: A drawing borad in C# Application Pin
amitmohanty25-Aug-05 17:34
amitmohanty25-Aug-05 17:34 

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.