My Table Stucture look like
OrderId int
OrderNo string
CustomerName string
AddDate DateTime
OrderDtlId int
OrderId int(FK from OrderMaster)
ProductId int(FK from ProductMaster)
Qty decimal
Rate decimal
My Table Stucture look like
OrderId int
OrderNo string
CustomerName string
AddDate DateTime
OrderDtlId int
OrderId int(FK from OrderMaster)
ProductId int(FK from ProductMaster)
Qty decimal
Rate decimal
Hello Thanks for reply. Every application has own problems and benefits.
Hello All, I want to develop Master Details CRUD option. I have seen lots of examples in which developed using GRID but my requirement is different than this. Let me explain with an example -------Master Part------- Order No__________ Order Date___________ Customer_______________ ----------Details Part------------ ProductName _____{Selection}______ Rate______ Qty____ [Add] -----------{GRID}-------------- Product1 20.00 1 [EDIT] [DELETE] Product2 50.00 1 [EDIT] [DELETE] [SAVE][CANCEL] Please check this -> Example screen
Hello All, This is my first application in asp.net core Table Like this ->
PublisherMater : PublisherId,PublisherName,TotalBooks
PublisherDetails: BookName,ReleaseDate,AuthorName
My question is : I want to manage master and details entry using asp.net core mvc with code first approch. first step : Create Model secound : Create MVC Controller with view using Entity Framework anybody have any example like this ? Thanks in advance
Hello All, From my site user can login and manage it's document. I need to create user wise FTP account where user can login in FTP . From that FTP credential user can download and upload file. Admin of this site access that document . Admin can download all users files. For that i need help. 1) Create FTP user on server where site is publish from c# code. 2) Create User wise folder with user wise permission. 3) Other user can not see other user folder. Admin have all user wise folder rights. All things manage from c# code. Thanks in Advance. Have great day.
Hello All, I have question about testing my web application in window phone. i was made one application in Asp.net(c#) in this application i use Canvas Control for users digital signature. my application working fine in Android and i-phone application . Now i want to test this application on window phone . so there is any way to test application in window phone from my Visual Studio 2012 or any Emulator for that. Thanks Sanket
Hello All, I have question about testing my web application in window phone. i was made one application in Asp.net(c#) in this application i use Canvas Control for users digital signature. my application working fine in Android and i-phone application . Now i want to test this application on window phone . so there is any way to test application in window phone from my Visual Studio 2012 or any Emulator for that. Thanks Sanket
public void GetDatainArr()
{
string strSQl = "";
string[] Arr = new string[50];
strSQl = "select [Id] from [tblname] ";
DataTable dt = GetDataTable(strSQl); //GetDataTable function
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Arr[i] = Convert.ToString(dt.Rows[i][0]);
}
}
}
public DataTable GetDataTable(string Sql)
{
SqlConnection conn = new SqlConnection("ConnectionString ");
conn.Open();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand(Sql, conn);
SqlDataAdapter ad = new SqlDataAdapter();
ad.Fill(dt);
conn.Close();
return dt;
}
This code in C# so you can Convert this code in vb using this link http://www.developerfusion.com/tools/convert/csharp-to-vb/
Sanket Gandhi
you can also write like this.. //this line write before for loop //with this line grid(dataGridView1) create line as per dataTable(t) dataGridView1.RowCount=t.Rows.Count for (int i = 0; i < t.Rows.Count; i++) { dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[0]["Address"].ToString(); }
you can also write like this.. //this line write before for loop //with this line grid(dataGridView1) create line as per dataTable(t) dataGridView1.RowCount=t.Rows.Count for (int i = 0; i < t.Rows.Count; i++) { dataGridView1.Rows[i].Cells["Column1"].Value = t.Rows[0]["Address"].ToString(); }
I am Making Application in visual studio 2010 in windows form using C# I want to get scan images from scanner. How can i do??? Please help Thank You Sanket
I am Making one Window Form in visual studio 2010 using c# in this Form I want To Show Lost of Images and this images come form specific path or From folder Example: There is one hospital LeftHead side Patient List On click of PatientName in next panal I want show some related images of this patient so in this case what kind of tool i use to solve this problem Thank You Sanket
I am Making one Window Form in visual studio 2010 using c# in this Form I want To Show Lost of Images and this images come form specific path or From folder Example: There is one hospital LeftHead side Patient List On click of PatientName in next panal I want show some related images of this patient so in this case what kind of tool i use to solve this problem Thank You Sanket
Hi All , I am Working In Visual Studio 2010. I am Making Dashboard in WindowsFormsApplication Project. I am Using SqlServer2005 for database.I take two DataGridView in one form in first grid i fill data on form load event. In second grid change value on click of first grid. Now i want to change value in second grid using keyboard arrow key.. Please Help me....
Hi All , I am Working In Visual Studio 2010. I am Making Dashboard in WindowsFormsApplication Project. I am Using SqlServer2005 for database.I take two DataGridView in one form in first grid i fill data on form load event. In second grid change value on click of first grid. Now i want to change value in second grid using keyboard arrow key.. Please Help me....
Hi All , I am Working In Visual Studio 2010. I am Making Dashboard in WindowsFormsApplication Project using C#. I am Using SqlServer2005 for database.I take two DataGridView in one form in first grid i fill data on form load event. In second grid change value on click of first grid. Now i want to change value in second grid using keyboard arrow key.. Please Help me....
I am Making Dashbord in .net C#. I want to open some module whis is made in VB6. when i add module dll in Dashbord open form but grid not display