TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sujeet Raman
856
927
349.5k
Columns and rows not adding dynamicaly in C# Datatable
Aug 30 2020 1:12 AM
I am learning about dynamic datatable creation from stored procedure results in C#, but I ran into a problem. I have a stored procedure which returns 2 tables as result, by using this table I need to create a separate datatable in C#. I am not able to dynamically add all the columns and rows in multiple data tables.
Function 1
public ExcelReportDetails createdataset()
{
DataSet ds = new DataSet();
ds = DataAdapter.SPArray2(storedProcedure);
}
Here in `ds`, I should get the dataset with all tables with values.
Function 2
public static DataSet SPArray2(string storedProcedureName)
{
DataSet Owndataset = new DataSet();
using (DataSet dataSet = ExecuteDataSet(cmd => ConfigureStoredProcCommand(cmd, storedProcedureName)))
{
Owndataset = dataSet.ToDataSet2();
}
return Owndataset;
}
Function 3
public static DataSet ToDataSet2(this DataSet dataset)
{
DataSet ownds2 = new DataSet();
for (var i = 0; i < dataset.Tables.Count; i++) //getting table count as 2. I am returning from stored procedure like key value pair.key-country,value-india
{
using (var table = dataset.Tables[i])
{
ownds2.Tables.Add( table.ToDataTable2());
}
}
return ownds2;
}
Function 4
public static DataTable ToDataTable2(this DataTable table)
{
DataTable owntable = new DataTable();
if (table.Rows.Count > 0)
{
for (var row = 0; row < table.Rows.Count; row++)
{
for (int i = 0; i < table.Columns.Count; i++)
{
owntable.Columns.Add(table.Columns[i]); // how do I add columns confused here
owntable.Rows.Add(table.Rows[row][i]); // how do I add rows confused here
}
}
}
return owntable;
}
Thanks a lot!
Reply
Answers (
6
)
how to write data into existing excel template using c#
Autocomplete Text box MVC