how to find the database name from code ?

Subin Thomas

7y998.NET

i have one code and i have to find the table from which the data have been retrieved here is the code

private static DataSet ImportExcelXLS(string FileName, bool hasHeaders)
{
string HDR = hasHeaders ? "Yes" : "No";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=" + HDR + ";IMEX=1\"";
DataSet output = new DataSet();
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in dt.Rows)
{
string sheet = row["TABLE_NAME"].ToString();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + sheet + "]", conn);
cmd.CommandType = CommandType.Text;
DataTable outputTable = new DataTable(sheet);
output.Tables.Add(outputTable);
new OleDbDataAdapter(cmd).Fill(outputTable);
}
}
return output;
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
In this method ImportExcelXLS, you have first parameter as filename and that is the Excel file and by using that file we are retrieving the data. If you put a breakpoint then you can know easily.
Subin Thomas7y ago
okay its extracting from excel file how will i find that excel file salman
Salman Beg7y ago
Here you are retrieving the data from an Excel file. If in the Excel file if it contains 5 sheet then first it is retrieving all the sheet into a datatable. After that it is looping that dt and retrieving each sheet name. Also based on the sheet name it is retrieving all the data. Thanks.
Subin Thomas7y ago
hey madan i have no permission to edit or do anything with code extra i just have to identify the table name by going through the code
Subin Thomas7y ago
hi salman can you explain a bit more
Subin Thomas7y ago
hey madan thanks for the code but i cant figit with the code i have only told to recognise from which table the data is coming from
Madan Shekar7y ago
try this one also
public List<string> GetDatabaseList()
{
List<string> list = new List<string>();
// Open connection to the database
string conString = "server=xeon;uid=sa;pwd=manager; database=northwind";
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
// Set up a command with the given query and associate
// this with the current connection.
using (SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", con))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
list.Add(dr[0].ToString());
}
}
}
}
return list;
}
Madan Shekar7y ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
namespace SQLTableListInCSharp {
class Program {
static void Main(string[] args) {
string connectionString = "Data Source=.; Integrated Security=True;";
using(SqlConnection con = new SqlConnection(connectionString)) {
con.Open();
using(SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", con)) {
using(SqlDataReader dr = cmd.ExecuteReader()) {
while (dr.Read()) {
Console.WriteLine(dr[0].ToString());
}
}
}
}
}
}
}
Salman Beg7y ago
Hey. string sheet = row["TABLE_NAME"].ToString(); In this code you will get the sheet name of Excel file. As this code in for loop so as many number of sheet present in Excel sheet that many times you will get the sheet name. Thanks.