How to create dynamic model using created dynamic table?

Question

i Wan to create dynamic model using created dynamic table please give me the best solutions?

Siddharth Gajbhiye · Answer

Hello Rahul     Please refer the below link   https://stackoverflow.com/questions/29676230/how-to-use-a-dynamic-model-to-create-a-dynamic-table   it might slove your problem     Thanku

Laxmidhar Sahoo · Answer

hi Thanks Whether the webclient  respence or not if yes so Can you show me the data structure that the webclient respence.

Rahul Kumar · Answer

Hi Laxmidhar,
Thanks for giving me response, Actualy what i want,  i will explane you breifly
featchin data from API like--
public void CreateDynamicTable()
{
using (WebClient apiData = new WebClient())
{
var json = apiData.DownloadString("http://localhost:64086/api/us/Values/GetAllData");
string valueOriginal = Convert.ToString(json);
DataTable DtValue = ConvertJsonToDatatable(valueOriginal);
string createTableScript = CreateTABLEQuery("TestTable", DtValue);
DropIfExitTable("TestTable");
ExuecuteSqlQuery(createTableScript);
SqlCommand insert = CreateInsertQuery("TestTable", DtValue);
BatchInsertUpdate(DtValue, insert, 10);
}
}
using given data i create dynamic table like -
public static string CreateTABLEQuery(string tableName, DataTable table)
{
string sqlsc;
sqlsc = "CREATE TABLE " + tableName + "(";
for (int i = 0; i
{
sqlsc += "
 [" + table.Columns[i].ColumnName + "] ";
string columnType = table.Columns[i].DataType.ToString();
switch (columnType)
{
case "System.Int32":
sqlsc += " int ";
break;
case "System.Int64":
sqlsc += " bigint ";
break;
case "System.Int16":
sqlsc += " smallint";
break;
case "System.Byte":
sqlsc += " tinyint";
break;
case "System.Decimal":
sqlsc += " decimal ";
break;
case "System.DateTime":
sqlsc += " datetime ";
break;
case "System.Boolean":
sqlsc += " bit ";
break;
case "System.String":
default:
sqlsc += string.Format(" nvarchar({0}) ", table.Columns[i].MaxLength == -1 ? "max" : table.Columns[i].MaxLength.ToString());
break;
}
if (table.Columns[i].AutoIncrement)
sqlsc += " IDENTITY(" + table.Columns[i].AutoIncrementSeed.ToString() + "," + table.Columns[i].AutoIncrementStep.ToString() + ") ";
if (!table.Columns[i].AllowDBNull)
sqlsc += " NOT NULL ";
sqlsc += ",";
}
return sqlsc.Substring(0, sqlsc.Length - 1) + "
)";
}
now using this table i want to crate dynamic model whenever API will be change automatic model will be change, is it possible?

Laxmidhar Sahoo · Answer

1-I f data  is  taken from database and dynamilly create html table bellow  is  the link   https: //www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/    2-Otherwise  if  you want to create a table  in  database dynamically bellow  is  the code .         protected   void  CreateTable( object  sender, EventArgs e)   {        string  query =  "IF OBJECT_ID('dbo.CustomersTest', 'U') IS NULL " ;       query +=  "BEGIN " ;       query +=  "CREATE TABLE [dbo].[CustomersTest](" ;       query +=  "[CustomerId] INT IDENTITY(1,1) NOT NULL CONSTRAINT pkCustomerId PRIMARY KEY," ;       query +=  "[Name] VARCHAR(100) NOT NULL," ;       query +=  "[Country] VARCHAR(50) NOT NULL" ;       query +=  ")" ;       query +=  " END" ;        string  constr = ConfigurationManager.ConnectionStrings[ "constr" ].ConnectionString;        using  (SqlConnection con =  new  SqlConnection(constr))       {            using  (SqlCommand cmd =  new  SqlCommand(query))           {               cmd.Connection = con;               con.Open();               cmd.ExecuteNonQuery();               con.Close();           }       }   }         3- If something  else  please convey with more examples      Thanks

Rahul Kumar · Answer

i want to create dynamic model using dynamic table? for example-   I have a dynamic table properties like Id, Name, Salary  this table creating by API when api is change properties authomatic change like id, name, salary, address    using this i want to create dynamic model.

Laxmidhar Sahoo · Answer

hi Would you like to create dynamic object from datatable or something different