在ado.net中,dataset,datacolumn等,能像int那樣被用來作為申明變量時的數據類型麻?? 但是,我後面引用 efg 的時候,提示出錯 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 using System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.ComponentModel;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;namespace MyWebApp{ /// <summary> /// Summary description for Class1. /// </summary> public class Class1 {public string getupdsql(DataTable cds_in, string tablename_in, int unlast_in) { int i,j,n; string sql_out,ls_sql,ls_fn,ls_ft,ls_m; DataTable lcds_t; DataColumn ls_f; lcds_t = DataTable.Create(Application); j = unlast_in; if(j>cds_in.DataColumnCount) { j = cds_in.DataColumnCount; } ls_sql ="Select Top 1 * From" + tablename_in; lcds_t.Columns = get_data(ls_sql); if(j>lcds_t.DataColumnCount) { j = lcds_t.DataColumnCount; } sql_out = "Update" + tablename_in + " set"; for(i=0;i<=j-1;i++) { ls_fn = trim(cds_in.Columns[i].name); sql_out = sql_out + ls_fn + "="; ls_f = cds_in.FieldByName(ls_fn); ls_ft = GetType(ls_f); ls_ft = ls_ft.Trim(); if(ls_ft="S") { ls_m = Quotedstr((lf_f as string)); ls_m = ls_m.Replace('"','”') ; ls_m = ls_m.Replace("''", "’") ; ls_m = ls_m.Replace("’’", "’"); } else { if(ls_ft="D") { sql_out = sql_out + f_DateTosql(lf_f as DateTime); } else { if(varisnull(lf_f as Variant)) { sql_out = sql_out + "0.00"; } else { F_SetFloatLen(cds_in, 4,j); sql_out = sql_out + trim(lf_f as string); } } } if(i<j-1) { sql_out = sql_out + ","; } else { sql_out = sql_out + ")"; } } return sql_out; } }}各位大哥,可以幫我指出這段代碼的錯誤麻???實在是不會,已經三天了的,謝謝大家 另外,上面get_data是連接數據庫,並操作 求一高效存储过程【带参数】 用户控件中,如何调用私有的JavaScript 电脑休眠与启动! Application问题 动态添加的按钮不响应事件 做个分页程序,进行前后分页的时候,页数怎样保存处理??? 大虾们帮帮忙。。。搬到新空间出错 如何生成网页? SOS...上传的问题请高手帮忙, 如何让水晶报表存储数据 RegularExpressionValidator控件的ValidationExpression怎么写? 请教各位大虾,如何将calendar选定的值作为texbox的输入,动态改变它的选择日期?
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.ComponentModel;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace MyWebApp
{
/// <summary>
/// Summary description for Class1.
/// </summary>
public class Class1
{
public string getupdsql(DataTable cds_in, string tablename_in, int unlast_in)
{
int i,j,n;
string sql_out,ls_sql,ls_fn,ls_ft,ls_m;
DataTable lcds_t;
DataColumn ls_f; lcds_t = DataTable.Create(Application);
j = unlast_in;
if(j>cds_in.DataColumnCount)
{
j = cds_in.DataColumnCount;
} ls_sql ="Select Top 1 * From" + tablename_in;
lcds_t.Columns = get_data(ls_sql);
if(j>lcds_t.DataColumnCount)
{
j = lcds_t.DataColumnCount;
} sql_out = "Update" + tablename_in + " set";
for(i=0;i<=j-1;i++)
{
ls_fn = trim(cds_in.Columns[i].name);
sql_out = sql_out + ls_fn + "=";
ls_f = cds_in.FieldByName(ls_fn);
ls_ft = GetType(ls_f);
ls_ft = ls_ft.Trim();
if(ls_ft="S")
{
ls_m = Quotedstr((lf_f as string));
ls_m = ls_m.Replace('"','”') ;
ls_m = ls_m.Replace("''", "’") ;
ls_m = ls_m.Replace("’’", "’");
}
else
{
if(ls_ft="D")
{
sql_out = sql_out + f_DateTosql(lf_f as DateTime);
}
else
{
if(varisnull(lf_f as Variant))
{
sql_out = sql_out + "0.00";
}
else
{
F_SetFloatLen(cds_in, 4,j);
sql_out = sql_out + trim(lf_f as string);
}
}
}
if(i<j-1)
{
sql_out = sql_out + ",";
}
else
{
sql_out = sql_out + ")";
}
}
return sql_out;
}
}}
各位大哥,可以幫我指出這段代碼的錯誤麻???
實在是不會,已經三天了的,謝謝大家