我如何在数据库中调用记录从同一记录中获取值？ [英] How I Call A Record In Database Acourding To Values From The Same Record?

问题描述

我的表格包括以下字段：

（StockID，ProductID，ProName，ProSize，ProType，数量和价格）



i有CombName，CombSize和CombType的表单......

当我从CombName中选择产品名称时，我需要它在CombSize上显示相关尺寸，一旦我选择了尺寸，它就会显示相关类型ComType。



i在CombType上尝试了这个代码，但它带来了错误的数据

 const string ConnectionString =Provider = Microsoft.Jet.OLEDB.4.0; Data Source = | DataDirectory | StoreSys.mdb; 
 const string Query =SELECT TOP 1 StockID from Store WHERE ProSize =？; 
 
使用（var connection = new OleDbConnection（ConnectionString））
 using（var command = new OleDbCommand（Query，connection））
 {
 // OleDb doesn'使用命名参数，所以这里只有顺序：
 command.Parameters.AddWithValue（p0，combProdSize.Text）; 
 
 
 connection.Open（）; 
 txtStockID.Text = Convert.ToString（command.ExecuteScalar（））; 
 
} 
 

表中的数据

StockID ProductID ProName ProType ProSize数量售价

1 1普利司通TC10 175 / 70R13 668 100

2 1普利司通MY02 185 / 65R14 90 110

3 1普利司通TC10 185 / 70R14 475 100

4 1普利司通AR20 215 / 60R16 760 115

5 1普利司通AR20 225 / 55R16 750 60

6 4韩泰K114 235 / 60R16 635 10

7 1普利司通TC10 185 / 65R15 77 99

8 10 GT径向GTR378 155 / 70R13 333 34

解决方案

检查Country - > State示例以便更好地理解。

请按照以下链接。



http://www.c-sharpcorner.com/uploadfile/rohatash/dropdownlist-with-country-state-and-city-in-asp-net/ [ ^

i have table with fields as following:
(StockID, ProductID, ProName, ProSize, ProType, Quantity and price)

i have form with CombName, CombSize and CombType...
What i need when i chose a product name from CombName it shows the related sizes on CombSize, and once i chose a size it shows the related type on ComType.

i have tried this code on CombType but it brings wrong data

const string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|StoreSys.mdb";
           const string Query = "SELECT TOP 1 StockID FROM Store WHERE ProSize = ?";

           using (var connection = new OleDbConnection(ConnectionString))
           using (var command = new OleDbCommand(Query, connection))
           {
               // OleDb doesn't use named parameters, so only the order matters here:
               command.Parameters.AddWithValue("p0", combProdSize.Text);


               connection.Open();
               txtStockID.Text = Convert.ToString(command.ExecuteScalar());

           }

data in the table
StockID ProductID ProName ProType ProSize Quantity Saleprice
1 1 Bridgestone TC10 175/70R13 668 100
2 1 Bridgestone MY02 185/65R14 90 110
3 1 Bridgestone TC10 185/70R14 475 100
4 1 Bridgestone AR20 215/60R16 760 115
5 1 Bridgestone AR20 225/55R16 750 60
6 4 Hankook K114 235/60R16 635 10
7 1 Bridgestone TC10 185/65R15 77 99
8 10 GT Radial GTR378 155/70R13 333 34

解决方案

Check the Country-->State example to understand better.
Follow the below link.

http://www.c-sharpcorner.com/uploadfile/rohatash/dropdownlist-with-country-state-and-city-in-asp-net/[^]

这篇关于我如何在数据库中调用记录从同一记录中获取值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！