Comments by Nishant.Chauhan80 (Top 106 by date)

but FIR No three digit showing only two digit like

FIR NO Showing

FIR:113 11
FIR:245 24

Showing only two digit when apply your query

How sir please give me some example

how to define my code please tell me

return View(dbhandle.GetAboutTitlepage().ToList<>); //error

see my code when i click edit button for call function error occur "JavaScript runtime error: Object doesn't support property or method 'edit"

please update my question error occur when edit button "JavaScript runtime error: Object doesn't support property or method 'edit"

Thanks sir

Thanku for reply sir I don't understand.

level indicate hierarchy
sde parent
AE child
JE subchild

i want to show only child data through by parent level

i want to show only child data by parent data (SDE-R2 00010104)

"16 Sh. Surinder AE-R2 0001010401 ELE16"

see my code

any example through javascript sha256

i want to use sha256

sorry richard i will remain remember next time.

second monitor means

please send me example

because i want generate runtime report on new window when close report then drop table

multiple records not insert temporary table through looping

please see my query and code

please check my code

thanku sir

but modalpop not hide and not working export pdf code

thanks sir

srry sir but this post brief explain please see this post

working thanks sir

i will try but not insert data into table

i will try 28 feb but not insert data same error

sorry sir void instead of string into method

dropdownlist value into dep1
my error "Cannot implicitly convert type 'void' to 'object' "

But sir on local server works fine same credentials

Thanks its work....

Thanks its work this code

no i don't want to change datatype into table

CREATE TABLE [dbo].[CompRecd](
[ID] [numeric](15, 0) IDENTITY(1,1) NOT NULL,
[ComCat] [varchar](200) NULL,
[ComSubCat] [varchar](200) NULL,
[Whom] [varchar](100) NULL,
[HouseNo] [varchar](200) NULL,
[City] [varchar](50) NULL,
[MobNo] [varchar](20) NULL,
[PhoNo] [varchar](25) NULL,
[EmailID] [varchar](200) NULL,
[Complaint] [varchar](1000) NULL,
[TimeStamp] [datetime] NULL,
[FileData] [varbinary](max) NULL,
[ComNo] [varchar](25) NULL,
[officer] [numeric](15, 0) NULL,
[from] [numeric](15, 0) NULL,
[CompSubCat2] [varchar](200) NULL,
[Locality] [varchar](100) NULL,
[Comment] [varchar](200) NULL,
[FileDataType] [varchar](100) NULL,
[ipaddress] [varchar](100) NULL,
[Mark_userid] [int] NULL,
CONSTRAINT [compid_pk] UNIQUE NONCLUSTERED

yes i want adding records by footer row but i want last record then hide

while (dr.Read())

yes sir....

sir spouse i have one anchor tag and two checkboxes when i click on anchor Tag automatically checked but checked only checkbox store id in anchor tag

how to dynamically store id in one checkbox

thanks a lot sir...

yes..

i want to fetch using javascript

how to use if else condition ..

i want to query c# if- else condition

i want to query c# if- else condition

i want to query c# if- else condition

plz sir brief explain with code

ActualDate is current date time of system

ok sir thanks i was thought any formula StartDate Vs Actual Complete Date ok i use current date thanks again

thanks a lot sir...

No Column already Exist ACompleteDate(Actual Complete Date) Column See On above My Table But How to calculate ACompleteDate(Actual Complete Date) Vs Start Date

which date insert in this column ACompleteDate(Actual Complete Date) Column

i want to insert Value in ACompleteDate(Actual Complete Date) Column but which value

Actually Sir.. Error Found after Con.Open(); Line

System.Data.OleDb.OleDbCommand cmd = con.CreateCommand();

where ? Before @xml in above store-p

thank you very much sir

how ?

your code is right i have generated "IProductService.cs" file but i dont know code (create,update delete) in this fields


internal void Create(Kendo.Mvc.Examples.Models.ProductViewModel product)
{
throw new NotImplementedException();
}

internal void Update(Kendo.Mvc.Examples.Models.ProductViewModel product)
{
throw new NotImplementedException();
}

internal void Destroy(Kendo.Mvc.Examples.Models.ProductViewModel product)
{
throw new NotImplementedException();
}

sir plz give one example display how do this..

ok i will try solve this...

plz sir explain brief

how ? please brief describe

i want to row color changing one by one using for loop in my Export Excel File my code following :


Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();


Microsoft.Office.Interop.Excel.Workbook workbook = excelApplication.Workbooks.Open(filename,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);






foreach (Excel.Worksheet wrkst1 in workbook.Worksheets)
{

Excel.Range usedrange = wrkst1.UsedRange;
usedrange.Columns.AutoFit();
wrkst1.Tab.Color = 279;



//Excel.Range formatRange;
//formatRange = wrkst1.get_Range("b1", "k6");
//formatRange.Interior.Color = System.Drawing.
//ColorTranslator.ToOle(System.Drawing.Color.YellowGreen);


//formatRange = wrkst1.get_Range("b7", "k20");
//formatRange.Interior.Color = System.Drawing.
//ColorTranslator.ToOle(System.Drawing.Color.Yellow);

Excel.Range rng = (Excel.Range)wrkst1.Cells[1, 1];
Excel.Range row = rng.EntireRow;
row.Insert(Excel.XlInsertShiftDirection.xlShiftDown, false);

//wrkst1.get_Range("E1", "F1").Merge(false);
Excel.Range chartRange;
chartRange = wrkst1.get_Range("E1");
chartRange.FormulaR1C1 = objModule.Title;
chartRange.HorizontalAlignment = 3;
chartRange.VerticalAlignment = 3;
//chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Green);
chartRange.Font.Size = 20;

//ColorConverter cc = new ColorConverter();
//wrkst1.Cells[1, 10].Interior.Color = ColorTranslator.ToOle((Color)cc.ConvertFromString("#F1DCDB"));


}


excelApplication.DisplayAlerts = false;
((Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1]).Delete();
workbook.Close(true, filename, null);
excelApplication.DisplayAlerts = true;


}

catch (Exception ex)
{
}


//return File(filename, "application/msexcel");
return File(filename, "application/x-excel", DateTime.Now.Ticks + "_Report.xlsx");
}

Not working this in my Code

ok mam i want add row in export excel file because i want to show title on top excel my code following :-

MModule objModule = new MModule();
objModule.LoadModule(MID);
DatabaseObject objData = new DatabaseObject();
string file = DateTime.Now.Ticks + "_" + objModule.Title + ".xlsx";
System.IO.File.Copy(Server.MapPath("/Excel/Export/Atemplate.xlsx"), Server.MapPath("/Excel/Export/" + file));
string filename = Server.MapPath("/Excel/Export/" + file);
objData.Query = "SELECT * FROM " + objModule.TableName + "";
DataTable dtReport = objData.GetTable();
System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filename + ";Mode=ReadWrite;Extended Properties=\"Excel 12.0 Xml;HDR=Yes;Readonly=False;IMEX=0;\"");
con.Open();
System.Data.OleDb.OleDbCommand cmd = con.CreateCommand();
string tableString = "";
string ColString = "";
for (int i = 0; i < dtReport.Columns.Count; i++)
{
tableString += "[" + dtReport.Columns[i].Caption + "] varchar(255),";
ColString += "[" + dtReport.Columns[i].Caption + "],";

}
tableString = tableString.Substring(0, tableString.Length - 1);
try
{
ColString = ColString.Substring(0, ColString.Length - 1);

//***************** Create Excel Sheet Table *********************//

cmd.CommandText = "CREATE TABLE [" + objModule.Title + "] ( " + tableString + ");";
cmd.ExecuteNonQuery();

string ValString = "";
for (int j = 0; j < dtReport.Rows.Count; j++)
{
ValString = "";
for (int i = 0; i < dtReport.Columns.Count; i++)
{

ValString += "'" + dtReport.Rows[j][i] + "',";
}
ValString = ValString.Substring(0, ValString.Length - 1);
cmd.CommandText = "Insert Into [" + objModule.Title + "] (" + ColString + ") Values (" + ValString + ");";

cmd.ExecuteNonQuery();
}
cmd.Dispose();
con.Dispose();
con.Close();

Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel.Workbook workbook = excelApplication.Workbooks.Open(filename,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);

foreach (Excel.Worksheet wrkst1 in workbook.Worksheets)
{
Excel.Range usedrange = wrkst1.UsedRange;
usedrange.Columns.AutoFit();
wrkst1.Tab.Color = 300;
Excel.Range formatRange;
formatRange = wrkst1.get_Range("b1", "k6");
formatRange.Interior.Color = System.Drawing.
ColorTranslator.ToOle(System.Drawing.Color.YellowGreen);
// wrkst1.Cells[1, 2] = "YellowGreen";

formatRange = wrkst1.get_Range("b7", "k20");
formatRange.Interior.Color = System.Drawing.
ColorTranslator.ToOle(System.Drawing.Color.Yellow);

//wrkst1.get_Range("b2", "e3").Merge(false);
//chartRange = wrkst1.get_Range("b2", "e3");
//chartRange.FormulaR1C1 = "Your Heading Here";
//chartRange.HorizontalAlignment = 3;
//chartRange.VerticalAlignment = 3;

i want to add title(header) above row then export data from table

My Question Skip Excel Row Not Table Data Row

My Question Skip Excel Row Not Table Data Row

My Question Skip Excel Row Not Table Data Row

My Question Skip Excel Row Not Table Data Row

where use Range.AutoFit Method

again same error..

where dont use convert

sir look my code with store-p again i hope you understand store-p

Again Error sir after Change this solution

where sir.. plz tell me

array variable results

iam really sorry sir plz.. check again my complete code

array value to display on screen

i want to print value into array In array results variable value print button onclick

thanku sir TOString remove this code its working

how to modify connection another machine

But how to connect connection other system i have also install sql server in other system

But sir how to check connection other system

thanku sir

sir i want share data online and install on multiple system it is possible clickonce

first step publish after that create setup using installsheild

thank u sir

ok solve this prblm thank u guys

yes sir but i want dont show id cell

in my table total cells 13 but i want dont show id column

thnks its working

thankyou so much sir

i also check correct display member & value member

i am understand plz explain

i want to add new column in my database table like unique id (primary key ) when import excel file to a table then automatic generate new add column to a table (unique id ) following code:-

protected void btnUpload_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string path = string.Concat((Server.MapPath("~/Data/" + FileUpload1.FileName)));
FileUpload1.PostedFile.SaveAs(path);
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;");

OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet3$]", OleDbcon);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(cmd);

OleDbcon.Open();
DbDataReader dr = cmd.ExecuteReader();

string con_str = @"Data Source=vaio\sqlexpress;Initial Catalog=dbemp;Integrated Security=True";

// Bulk Copy to SQL Server
SqlBulkCopy bulkInsert = new SqlBulkCopy(con_str);
bulkInsert.DestinationTableName = "tbdata";
bulkInsert.WriteToServer(dr);
OleDbcon.Close();
Array.ForEach(Directory.GetFiles((Server.MapPath("~/Data/"))), File.Delete);
Label1.ForeColor = Color.Green;
Label1.Text = "successfully inserted";
FetchData();
newrow();

}
else
{
Label1.ForeColor = Color.Red;
Label1.Text = "Please select the File";
}
}
public void FetchData()
{
SqlConnection con = new SqlConnection(@"Data Source=vaio\sqlexpress;Initial Catalog=dbemp;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select * from tbdata", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.DataBind();

}
public void newrow()
{
SqlConnection con;
SqlDataAdapter dladpt;
DataSet dldst;
DataTable mydt;

con = new SqlConnection(@"Data Source=vaio\sqlexpress;Initial Catalog=dbemp;Integrated Security=True");
dladpt = new SqlDataAdapter("select * from tbdata", con);
dldst = new DataSet();
mydt = new DataTable();
dladpt.Fill(mydt);

DataColumn dcolColumn = new DataColumn("Link", typeof(string));
mydt.Columns.Add(dcolColumn);

DataRow drowItem;

foreach (DataRow row in mydt.Columns)
{
drowItem = mydt.NewRow();
drowItem["Link"] = "secret";
mydt.Rows.Add(drowItem);
}
GridView1.DataSource = mydt;
GridView1.DataBind();
}
}

Thanks combobox1.text its working

Not working this code

private void button1_Click(object sender, EventArgs e)
{
con.Open();

SqlCommand cmd = new SqlCommand("select * from tbadd where Dop between (@param1) and (@param2)", con);
cmd.Parameters.Add("@param1", SqlDbType.VarChar, 50).Value = dateTimePicker1.Value;
cmd.Parameters.Add("@param2", SqlDbType.VarChar, 50).Value = dateTimePicker2.Value;

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(ds,"sr");
dataGridView1.DataSource = ds.Tables["sr"];
con.Close();
}

but i use two datetimepicker