my question:: i'am use sybase database ,and ,i can connect it use odbcconnection ,but ,i can't use my store procedure ,can you tell me why ?? this is my code : --------------------------------------- using System; using System.Data; using Microsoft.Data.Odbc; namespace study { public class getds { public DataSet swdjb(string id_wjdm) { string cncstr= "Driver={Sybase System 11};srvr=zap;DB=tax_js;UID=sa;PWD=;" ; Microsoft.Data.Odbc.OdbcConnection cnc=new OdbcConnection(cncstr); OdbcCommand cmd=new OdbcCommand("fff",cnc); cmd.CommandType=CommandType.StoredProcedure; OdbcParameter wjdmparameter=new OdbcParameter("@id_wjdm",OdbcType.Char,7); wjdmparameter.Value=id_wjdm.Trim(); cmd.Parameters.Add(wjdmparameter); cnc.Open(); cmd.ExecuteNonQuery(); DataSet ds=new DataSet(); OdbcDataAdapter da=new OdbcDataAdapter(); da.SelectCommand=cmd; da.Fill(ds,"fd"); return ds; } } } ================================ using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls;namespace study { /// <summary> /// sysbasecnc 的摘要说明。 /// </summary> public class sysbasecnc : System.Web.UI.Page { protected System.Web.UI.WebControls.LinkButton next; protected System.Web.UI.WebControls.LinkButton pre; protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.DropDownList DropDownList1; protected System.Web.UI.WebControls.DataGrid DataGrid1; private void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { bind(); } } private void bind() { study.getds getdata=new study.getds(); DataSet ds=getdata.dd(); DataGrid1.DataSource=ds.Tables[0].DefaultView;; DataGrid1.DataBind(); }
i'am use sybase database ,and ,i can connect it use odbcconnection ,but ,i can't
use my store procedure ,can you tell me why ??
this is my code :
---------------------------------------
using System;
using System.Data;
using Microsoft.Data.Odbc;
namespace study
{
public class getds
{
public DataSet swdjb(string id_wjdm)
{
string cncstr= "Driver={Sybase System 11};srvr=zap;DB=tax_js;UID=sa;PWD=;" ;
Microsoft.Data.Odbc.OdbcConnection cnc=new OdbcConnection(cncstr);
OdbcCommand cmd=new OdbcCommand("fff",cnc);
cmd.CommandType=CommandType.StoredProcedure;
OdbcParameter wjdmparameter=new OdbcParameter("@id_wjdm",OdbcType.Char,7);
wjdmparameter.Value=id_wjdm.Trim();
cmd.Parameters.Add(wjdmparameter);
cnc.Open();
cmd.ExecuteNonQuery();
DataSet ds=new DataSet();
OdbcDataAdapter da=new OdbcDataAdapter();
da.SelectCommand=cmd;
da.Fill(ds,"fd");
return ds;
}
}
}
================================
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;namespace study
{
/// <summary>
/// sysbasecnc 的摘要说明。
/// </summary>
public class sysbasecnc : System.Web.UI.Page
{
protected System.Web.UI.WebControls.LinkButton next;
protected System.Web.UI.WebControls.LinkButton pre;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
bind();
}
} private void bind()
{
study.getds getdata=new study.getds();
DataSet ds=getdata.dd();
DataGrid1.DataSource=ds.Tables[0].DefaultView;;
DataGrid1.DataBind();
}
===================
thank you !!!!