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

How to create dynamic model using created dynamic table?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)