تبدیل دیتا بیس به یکدیکر

[com928]

سلام
من قبلا دیتابیسم اس کیو ال بود و به راحتی از طریق استور پروسیجر یک صفحه جستجوی پیشرفته تو سایتم گذاشتم که کار میکرد حالا دیتا بیسم اکسس هست و بایداین جستجوی پیشرفته را هم در سایتم داشته باشم میخاستم بدونم باید چکار کنم درضمن تو اینترنتم یک گشت زدم دیدم نرم افزار تبدیل دیتابیس به یکدیگر هست نمیدونم تا حالا کسی استفاده کرده به درد میخوره یا نه ممنون میشم راهنماییم کنید.

[fakhravari]

یعنی استور شما چطوری که تابع های نمونش در access نیست:متفکر:

[com928]

پروسیجرم به این صورت
ALTER PROCEDURE [dbo].[SearchHigh]
(
@Fname nvarchar(50),
@Lname nvarchar(50),
@Job nvarchar(50),
@DataBirth nvarchar(50),
@Zoon nvarchar(50),
@City nvarchar(50),
@Street nvarchar(50),
@Store nvarchar(50),
@Mobile nvarchar(50),
@Tell nvarchar(50)
)
AS
BEGIN
SET NOCOUNT ON;
declare @sql nvarchar(max) set @sql = 'select * from customer where ';
if (@Fname !='') set @sql = @sql + 'Fname = N''' + @Fname + ''' and ' ;
if (@Lname !='') set @sql = @sql + 'Lname = N''' + @Lname + ''' and ' ;
if (@Job !='') set @sql = @sql + 'Job = N''' + @Job + ''' and ';
if (@DataBirth !='') set @sql = @sql + 'DataBirth = N''' + @DataBirth + ''' and ';
if (@Zoon !='') set @sql = @sql + 'Zoon = ' + @Zoon + ' and ' ;
if (@City !='') set @sql = @sql + 'City = N''' + @City + ''' and ';
if (@Street !='') set @sql = @sql + 'Street = N''' + @Street + ''' and ';
if (@Store !='') set @sql = @sql + 'Store = N''' + @Store + ''' and ';
if (@Mobile !='') set @sql = @sql + 'Mobile = N''' + @Mobile + ''' and ' ;
if (@Tell !='') set @sql = @sql + 'Tell = N''' + @Tell + ''' and ';
set @sql = @sql + '1=1';
exec (@sql);
END

من با اکسس در حد کوئری زدن بلدم نمیدونم تابع های نمونش به چه صورت اگه میشه یک مرجعی بهم معرفی کنیدممنون میشم

[fakhravari]

شما میتوانیداینو در یک SqlCommand راحت بنویسید برای مثال
public DataTable Pr_Ep_Cus_Tea(short ddl, short Select, string txt)
{
SqlConnection con = new SqlConnection(sql);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
#region Teacher
if (ddl == 2)
{
if (Select == 0)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Teachers.ID, Persons.FatherName, Persons.NationalCode FROM Persons INNER JOIN Teachers ON Persons.ID = Teachers.PersonID WHERE Persons.Family like N'%" + txt + "%'";
}
if (Select == 1)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Teachers.ID, Persons.FatherName, Persons.NationalCode FROM Persons INNER JOIN Teachers ON Persons.ID = Teachers.PersonID WHERE Persons.NationalCode like N'%" + txt + "%'";
}
if (Select == 2)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Teachers.ID, Persons.FatherName, Persons.NationalCode FROM Persons INNER JOIN Teachers ON Persons.ID = Teachers.PersonID WHERE Teachers.ID =" + Int16.Parse(txt) + "";
}
}
#endregion
#region Customer
if (ddl == 1)
{
if (Select == 0)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Persons.FatherName, Persons.NationalCode, Customers.ID FROM Persons INNER JOIN Customers ON Persons.ID = Customers.PersonID WHERE Persons.Family like N'%" + txt + "%'";
}
if (Select == 1)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Persons.FatherName, Persons.NationalCode, Customers.ID FROM Persons INNER JOIN Customers ON Persons.ID = Customers.PersonID WHERE Persons.NationalCode like N'%" + txt + "%'";
}
if (Select == 2)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Persons.FatherName, Persons.NationalCode, Customers.ID FROM Persons INNER JOIN Customers ON Persons.ID = Customers.PersonID WHERE Customers.ID =" + Int16.Parse(txt) + "";
}
}
#endregion
#region Employee
if (ddl == 0)
{
if (Select == 0)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Persons.FatherName, Persons.NationalCode, Employees.ID FROM Persons INNER JOIN Employees ON Persons.ID = Employees.PersonID WHERE Persons.Family like N'%" + txt + "%'";
}
if (Select == 1)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Persons.FatherName, Persons.NationalCode, Employees.ID FROM Persons INNER JOIN Employees ON Persons.ID = Employees.PersonID WHERE Persons.NationalCode like N'%" + txt + "%'";
}
if (Select == 2)
{
cmd.CommandText = "SELECT Persons.Name + ' ' + Persons.Family AS nf, Persons.FatherName, Persons.NationalCode, Employees.ID FROM Persons INNER JOIN Employees ON Persons.ID = Employees.PersonID WHERE Employees.ID =" + txt + "";
}
}
#endregion
#region Personal
if (ddl == 3)
{
if (Select == 0)
{
cmd.CommandText = "SELECT Name + ' ' + Family AS nf, FatherName, NationalCode, ID FROM Persons WHERE Family like N'%" + txt + "%'";
}
if (Select == 1)
{
cmd.CommandText = "SELECT Name + ' ' + Family AS nf, FatherName, NationalCode, ID FROM Persons WHERE NationalCode like N'%" + txt + "%'";
}
if (Select == 2)
{
cmd.CommandText = "SELECT Name + ' ' + Family AS nf, FatherName, NationalCode, ID FROM Persons WHERE ID =" + Int16.Parse(txt) + "";
}
}
#endregion

con.Open();

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();

da.Fill(dt);
con.Close();
return dt;

}
اینو برای نمونه دادم تا راه یاد بگیرید.