如何创建一个OleDbCommand Class使用的StoredProcedure?

carlton 2002-11-05 06:56:41

VS.Net中是否有这样的工具?
Acess能办到吗？
谢谢！

...全文

87 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

TheAres 2002-11-10

打赏
举报

OleDbConnection cn = new OleDbConnection(strConn);
cn.Open();

OleDbCommand cmd = cn.CreateCommand();
cmd.CommandText = "GetCustomer";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CustomerID", OleDbType.WChar, 5);
cmd.Parameters[0].Value = "ALFKI";

OleDbDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
Console.WriteLine(rdr["CompanyName"]);
else
Console.WriteLine("No customer found");

rdr.Close();
cn.Close();

原文： Write code to reverse a C-Style String. (C-String means that “abcd” is represented as five characters, including the null character.) 译文：写代码翻转一个C风格的字符串。(C风格的意思是"abcd"需要用5个字符来表示，包含末尾的结...

Check if the two strings have identical character counts. 方法1：对两个字符串分别排序，然后判断是否相等。但会破坏原字符串方法2：用一个O(1)的额外空间来记录，每个字符出现的次数。不会破坏原字符串 package Arrays_Strings; import java.util.Arrays; publ

原文： Write a method to replace all spaces in a string with ‘%20’. 译文：写一个函数，把字符串中所有的空格替换为%20 。先计算出空格个数，然后从后往前逐个替换空格，不用新开数组 package Arrays_Strings; import CtCILibrary.AssortedMethod

原文： Assume you have a method isSubstring which checks if one word is a substring of another. Given two strings, s1 and s2, write code to check if s2 is a rotation of s1 using only one call to isSub

Implement a method to perform basic string compression using the counts of repeated characters. For example, the string aabcccccaaa would become a2blc5a3. If the “compressed” string would not become s