没有检索值 [英] Not retrieving values

问题描述

大家好，


我正面临一个非常奇怪的问题，我正在执行存储过程

驻留在Sybase数据库中。当我从SQL Advantage执行存储的

过程时，我可以重新检索这些值，但是当我从.net代码执行相同的操作时（VS.net 2003 C sharp） ）与

相同的参数集我不会检索任何值。请帮帮我

弄清楚。


提前致谢，

Nishanth

解决方案

如果您发布了用于检索数据的代码，那么找出错误会更容易。


Robin S.

Ts''i mahnu uterna ot twan ot geifur hingts uto。

--------- ---------------------------------------

Nishanth ; < ra ********** @ gmail.comwrote in message

news：11 ******************** **@m58g2000cwm.googlegr oups.com ...

大家好，


我面临一个非常特殊的问题，我正在执行存储过程

驻留在Sybase数据库中。当我从SQL Advantage执行存储的

过程时，我可以重新检索这些值，但是当我从.net代码执行相同的操作时（VS.net 2003 C sharp） ）与

相同的参数集我不会检索任何值。请帮帮我

弄清楚。


提前致谢，

Nishanth

这是用于直接连接到数据库的代码

private void CallSp（）

{

DataSet dsProject = new DataSet（）;

string startDate =" 06/21/2002" ;

string EndDate ="" ;;

string AccountType =" A";


string UserId =" " ;

string strMess ="" ;;


尝试

{

string constr = string.Empty;

constr =" Provider = Sybase.ASEOLEDBProvider.2; Initial

Catalog = testdb; Password = testpass; User ID = testuser; Data

Source = IISS; Persist Security Info = True;" ;;


OleDbConnection conn = new OleDbConnection（constr）;


if（conn.State！= ConnectionState.Open）

conn.Open（）;


OleDbCommand adptComm = new

OleDbCommand（" sp_crm_top_holding"，conn）;

adptComm.CommandType = CommandType.StoredProcedure;

OleDbParameter parameter = adptComm.Parameters.Add（

" @ from_date"，OleDbType.VarChar）;

parameter.Value = startDate;


parameter = adptComm.Parameters.Add（

" @ to_date"，OleDbType.VarChar）;

parameter.Value = EndDate;


parameter = adptComm.Parameters.Add（< br / >
" @ acct_type"，OleDbType.VarChar）;

parameter.Value = AccountType;


parameter = adptComm.Parameters.Add（

" @ username"，OleDbType.VarChar）;

parameter.Value = UserId;


parameter = adptComm.Parameters .Add（

" @ messagenet_num"，OleDbType.VarChar）;

parameter.Value = strMess;


OleDbDataAdapter adpt = new OleDbDataAdapter（adptComm）;


adpt.Fill（dsProject）;

conn.Close（）;

响应。写（dsProject.Tables [0] .Rows.Count）;


}

catch（exception ex）

{

Response.Write（ex.Message）;

}


}

Okayu，我没有看到任何明显不合理的原因。

您是否设法使用.Net读取Sybase数据库？


Robin S.

----------------------------- -------------- -------

" Nishanth" < ra ********** @ gmail.comwrote in message

news：11 ******************** **@v33g2000cwv.googlegr oups.com ...

这是用于直接连接数据库的代码


private void CallSp（）

{

DataSet dsProject = new DataSet（）;

string startDate =" 06/21 / 2002" ;

string EndDate ="" ;;

string AccountType =" A";


string UserId =" " ;

string strMess ="" ;;


尝试

{

string constr = string.Empty;

constr =" Provider = Sybase.ASEOLEDBProvider.2; Initial

Catalog = testdb; Password = testpass; User ID = testuser; Data

Source = IISS; Persist Security Info = True;" ;;


OleDbConnection conn = new OleDbConnection（constr）;


if（conn.State！= ConnectionState.Open）

conn.Open（）;


OleDbCommand adptComm = new

OleDbCommand（" sp_crm_top_holding"，conn）;

adptComm.CommandType = CommandType.StoredProcedure;

OleDbParameter parameter = adptComm.Parameters.Add（

" @ from_date"，OleDbType.VarChar）;

parameter.Value = startDate;


parameter = adptComm.Parameters.Add（

" @ to_date"，OleDbType.VarChar）;

parameter.Value = EndDate;


parameter = adptComm.Parameters.Add（

" @@ acct_type"，OleDbType.VarChar）;

parameter.Value = AccountType;


parameter = adptComm.Parameters.Add（

" @ username"，OleDbType.VarChar）;

parameter.Value = UserId;


parameter = adptComm.Parameters.Add（

" @ messagenet_num"，OleDbType.VarChar）;

parameter.Value = strMess;


OleDbDataAdapter adpt = new OleDbDataAdapter（adptComm） ）;


adpt.Fill（dsProject）;

conn.Close（）;

Response.Write（dsProject.Tables） [0] .Rows.Count）;


}

catch（例外情况）

{

Response.Write（ex.Message）;

}


}

Hi All,

I am facing a very peculiar problem, I am executing a stored procedure
residing in the Sybase database. When I do execute the Stored
Procedure from SQL Advantage I can retrexecve the values, but when I
execute the same from the .net code (VS.net 2003 C sharp) with the
same set of parameters I don''t retrieve any values. Please help me
figure out the same.

Thanks in advance,
Nishanth

解决方案

It would be easier to figure out what was wrong if you posted the code you
are using to retrieve the data.

Robin S.
Ts''i mahnu uterna ot twan ot geifur hingts uto.
------------------------------------------------
"Nishanth" <ra**********@gmail.comwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...

Hi All,

I am facing a very peculiar problem, I am executing a stored procedure
residing in the Sybase database. When I do execute the Stored
Procedure from SQL Advantage I can retrexecve the values, but when I
execute the same from the .net code (VS.net 2003 C sharp) with the
same set of parameters I don''t retrieve any values. Please help me
figure out the same.

Thanks in advance,
Nishanth

This is the code that is used to directly connect to the db

private void CallSp()
{
DataSet dsProject = new DataSet() ;
string startDate = "06/21/2002" ;
string EndDate = "";
string AccountType = "A";

string UserId = "" ;
string strMess = "";

try
{
string constr = string.Empty;
constr = "Provider=Sybase.ASEOLEDBProvider.2;Initial
Catalog=testdb;Password=testpass;User ID=testuser;Data
Source=IISS;Persist Security Info=True;";

OleDbConnection conn = new OleDbConnection(constr);

if(conn.State != ConnectionState.Open)
conn.Open();

OleDbCommand adptComm = new
OleDbCommand("sp_crm_top_holding",conn);
adptComm.CommandType = CommandType.StoredProcedure;
OleDbParameter parameter = adptComm.Parameters.Add(
"@from_date", OleDbType.VarChar);
parameter.Value = startDate ;

parameter = adptComm.Parameters.Add(
"@to_date", OleDbType.VarChar);
parameter.Value = EndDate ;

parameter = adptComm.Parameters.Add(
"@acct_type", OleDbType.VarChar);
parameter.Value = AccountType ;

parameter = adptComm.Parameters.Add(
"@username", OleDbType.VarChar);
parameter.Value = UserId ;

parameter = adptComm.Parameters.Add(
"@messagenet_num", OleDbType.VarChar);
parameter.Value = strMess ;

OleDbDataAdapter adpt=new OleDbDataAdapter(adptComm);

adpt.Fill(dsProject);
conn.Close();
Response.Write(dsProject.Tables[0].Rows.Count);

}
catch(Exception ex)
{
Response.Write(ex.Message) ;
}

}

Okayu, I don''t see any obvious reasons that wouldn''t work.

Have you managed to read from the Sybase database using .Net at all?

Robin S.
--------------------------------------------------
"Nishanth" <ra**********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

This is the code that is used to directly connect to the db

private void CallSp()
{
DataSet dsProject = new DataSet() ;
string startDate = "06/21/2002" ;
string EndDate = "";
string AccountType = "A";

string UserId = "" ;
string strMess = "";

try
{
string constr = string.Empty;
constr = "Provider=Sybase.ASEOLEDBProvider.2;Initial
Catalog=testdb;Password=testpass;User ID=testuser;Data
Source=IISS;Persist Security Info=True;";

OleDbConnection conn = new OleDbConnection(constr);

if(conn.State != ConnectionState.Open)
conn.Open();

OleDbCommand adptComm = new
OleDbCommand("sp_crm_top_holding",conn);
adptComm.CommandType = CommandType.StoredProcedure;
OleDbParameter parameter = adptComm.Parameters.Add(
"@from_date", OleDbType.VarChar);
parameter.Value = startDate ;

parameter = adptComm.Parameters.Add(
"@to_date", OleDbType.VarChar);
parameter.Value = EndDate ;

parameter = adptComm.Parameters.Add(
"@acct_type", OleDbType.VarChar);
parameter.Value = AccountType ;

parameter = adptComm.Parameters.Add(
"@username", OleDbType.VarChar);
parameter.Value = UserId ;

parameter = adptComm.Parameters.Add(
"@messagenet_num", OleDbType.VarChar);
parameter.Value = strMess ;

OleDbDataAdapter adpt=new OleDbDataAdapter(adptComm);

adpt.Fill(dsProject);
conn.Close();
Response.Write(dsProject.Tables[0].Rows.Count);

}
catch(Exception ex)
{
Response.Write(ex.Message) ;
}

}

这篇关于没有检索值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！