Posts
- public List<LDNo> LDNoList(Int64? LDNo)
- {
- ResultModel result = new Models.ViewModel.CommonViewModel.ResultModel();
- string error = String.Empty;
- QUERY2 query = new QUERY2();
- Dictionary<string, object> dict = new Dictionary<string, object>();//= new Dictionary<string, string>
- List<LDNo> ldnoList = new List<LDNo>();
- dict.Add("@LDNO", LDNo);
- dict.Add("@Result", 1.ToString());
- dict.Add("@Message", "Message".ToString());
- query.SQL = @"SPROC_GET_tblDyesForecastingHead_LDNO";
- query.PARAMETER = dict;
- clsDataprocess cls = new clsDataprocess();
- result = cls.ExecuteSqlStoredProcedureSaveEdit(query, "get", out error);
- if (result.Result && result.DtTable != null && result.DtTable.Rows.Count > 0)
- {
- Int64 tempi = 0;
- for (int i = 0; i < result.DtTable.Rows.Count; i++)
- {
- LDNo lDNo = new LDNo();
- Int64.TryParse(result.DtTable.Rows[i]["LDNO"].ToString(), out tempi);
- lDNo.LdNo = tempi;
- ldnoList.Add(lDNo);
- }
- string Message = result.Message;
- string Result = result.Result.ToString();
- }
- else if (!result.Result)
- {
- throw new Exception(result.Message);
- }
- return ldnoList;
- }
Showing posts with label Stored Procedure. Show all posts
Showing posts with label Stored Procedure. Show all posts
Thursday, November 1, 2018
Using SqlClient connect to sql server and CRUD in Databse thorough Stored Procedure
Muhammad Ashikuzzaman
November 01, 2018
0
