Comments by Shubh Agrahari (Top 176 by date)

hi, now i write my proc that is still giving exception....

can you clearly describe it with proper structure with four column(one row).....also with taking data from controls on button click

Tadit using jQery i found all the value in a variable after Add button click but how i bind that values on grid view is occurring bit typical. if that value i fetching from database then it will be done using Ajax and Jason but there is condition that i need to stare data virtually on grid view and the issue is this stuff need to done with Jquery not with Server side languages like C#

guys lets see a example like u need to save multiple rows at a time and before it u have to show that all value on a grid temporally ,u have four text box control and one button naming with Add ,on add click u have to show that four value on a grid with four column ,after adding multiple temporary row there is a button naming Save on this click u have to save all the grid rows in Database..........and all that i done in ma previous projects but with C# like with Data Table View State but on this project i need to do this with Client side code so i am using JQuery ....but i want only query for adding data in grid view virtually using Jquery.........and i am using Asp.net controls(three Text Boxes one Button and a Grid view) .......Now i think you all getting that what i want

its affecting ma other works on that same page so i m not using update panel..and can you explain that how can iframe maintain it ?

Thanks buddy i done it with some troubleshoot

string connString = "";
//string FileName = Path.GetFileName();
string strFileType = Path.GetExtension(fileuploadExcel.FileName).ToLower();
//string path = fileuploadExcel.PostedFile.FileName;
string path = Server.MapPath(fileuploadExcel.FileName);
var fileName = string.Format("{0}\\" + path + "", Directory.GetCurrentDirectory());
//Connection String to Excel Workbook
if (strFileType.Trim() == ".xls")
{
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (strFileType.Trim() == ".xlsx")
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
string query1 = "select [AppliedDistrictName],[ChalanNo],[MobileNoForApp],[ApplicantName],[FatherName],[MobileNo],[PermDistrict],[TempDistrict] from [Sheet1$]";
string query = "SELECT * FROM [" + path + "$]";
OleDbConnection conn = new OleDbConnection(connString);
if (conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand(query1, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();

da.Fill(ds);
grvExcelData.DataSource = ds.Tables[0];
grvExcelData.DataBind();
da.Dispose();
conn.Close();
conn.Dispose();

thanks

ya its true

thanks..there is a bit mistake now fine

thanks..there is a bit mistake now fine

i tried that also(removed []) but still not working and limit can be 0-15 chars

there is some fonts for barcode just search on google u just need to install that font and in parameter u need to put "*"+YourText+"*" like this using that font ...

Tell me one thing that modal popup extender working well?? means you saying its running well on the page but when u trying to use Model then its gonna blank so the general things you have to be know About Using Ajax Controls....solve it with reviewing Script manager and proper necessitous Panel and Model Popup Extender Control

and what do you mean by "it's not running properly."...share issues what error showing it.......that can help us to help you

but the main thing u forgetting dude that 1st u need to check the format of data and other many things..

You really need to search About folderBrowserDialog..what it do and all that...need little Practice...You need to 1st make object of folderBrowserDialog and then Call it with Open Property that Basically open the Dialog box for choosing Pictures....do Google About it

okk then try second link .

its nothing just playing with that specific paths.......

nice try thanks for reply

thanks its working....may i know that what the need of MS & FS here...?

hmm ya you can also use view state or Session...okk good but always maintain view state security after Use

explain your question...

yes but how can we define it...there is some other condition also embed that increase the need of multiple pages beside of MultiView but yes always do sort as you can

no where it sound like tabs..i read it again d'nt think so.....and if u have query then ask it

so what is a problem in asp.net.....

just use Sessions it helps better

whats the problem with it...

on list Box selection change event you only need to do.....

textbox1.text=listbox1.selecteditem.tostring()

so what you actually want...where Print dialogue box find the document that it need to print...explain your need that can help us to help.....

always buddy...

then why you converting this data into int type just as string send it to Query.

then now what happening ..???

putting break point you can major your code line by line...

why u r binding like this....
<asp:LinkButton ID="btnUpdate" runat="server" Text="Edit" CommandArgument="<%#((GridViewRow)Container).RowIndex %>" CommandName="update">

bind ur ID filed like this
<asp:LinkButton ID="btnUpdate" runat="server" Text="Edit" CommandArgument='<%#Eval("ID") %>' CommandName="update">

and after it just do like this

if (e.CommandName == "update")
{
LinkButton linbtnupdate = (LinkButton)e.CommandSource;
int ID= Convert.ToInt32(e.CommandArgument);

//now check with break point is int ID holding value of row ar not...
}

be definitive.......that help us to help you

query in the sense i am doing just xml data insert operation throw Procedure from VS 2005 to Sql Server 2008 and i am getting this when i am posting value via parameter but when i am inserting the same value throw SQL IDE text visualizer it inserting successfully.....

thanks friend but i done this..........by this
select CAST(CAST(@ToYear AS varchar) + '-' + CAST(@ToMonth AS varchar) + '-' + CAST(1 AS varchar) AS DATE) as ToDate from T_PayBill

i think u all r getting ma q.s wrong actually my main q.s is to know that why and in which condition this occurs....

ohh sry there is huge amount of code but i only want to know about Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack. Exceptoin why occur becoz the one thing is that when this ex occur there is no matter with program execution.

i am getting HH:MM::SS formate so can u give me the code including hour:Minute:Timer on Counter....?

it reload timer every time when page reload or refresh..

no its only part to convey u all people even there is many method to get store login time (session. hidden fields etc)

i tried it its nt working and one thing that if u r giving code of another persons,communities ar whatever that is not your own then its good to give link nt copy paste there code special same code event without edited even strings.. ..

Thanks SA for suggestion now have any solution........???

Basmeh Awad Thanks to giving attension....but sorry i cleared it boss.......

no its wrapping problem SA ma all control taking same place in container thats why only one control looks at runtime..i got ma answer but thanks to all.

thanks lukeer for giving sudden spark, i also think that my all control taking same place....

but there is did not showing property like ID in Intellisence in win form i think ID property stand in ASP.net but here Windows application there is id becomes Name property......

try on Google definitely got satisfied answer.

nice

best option ever is...........just googling googling and googling.....

what is data type of date column in db...?

try correct password.....according to updated mode

ma pleasure...but bad luck its down voted by someone

try your own connection string that successfully runs in previous problem...

good to attempt yourself and get succeed..

table content mean column name or all data of columns...?have any procedure..?

what results it giving.?
any exception or error?

can you clarify that actually what you want to do...

ya its ma pleasure if you got your answer then mark it accept solution.

ya always be ready to help...

okk below i give a link check that....

ya you should....try it its good

Is there anything specific in terms of non-functional requirements that you are looking for other than technology. I.E., level of data centre security, cost, bandwith allowance, redundancy etc?

what it mean.....what actually want to do...?

thanks sir

yap its ma pleasure buddy but also nice attempt by you also....its good quality to give peek of potential for trouble shooting....go ahead nice career waiting for us....

whats happening with your SELECT custName, custAdd, custPho
FROM custDetails, custTransaction
WHERE custTransaction.custID='"+textBox1.text+"' and custTransaction.custDueAmt < custDetails.custLimit; this code what error occurring...?

yes boss i am trying to serve as good as i can...but as start up i always use these queries....

sqlcon.Open();
string str = "select CONCAT(firstname, ' (' ,lastname,')') AS mixname from userdbase"; da = new MySqlDataAdapter(str, sqlcon);
DataSet ds = new DataSet();
da.TableMappings.Add("table", "userdbase");
da.Fill(ds, "userdbase");
this.ListBox1.DataSource = this.ds;
this.ListBox1.DataTextField = "userdbase.mixname ";
this.ListBox1.DataValueField = "userdbase.mixname";
sqlcon.Close();
da.Dispose();


here userdbase is your database name and also mixname is a virtual name that making to column as one at runtime... try this

buddy one thing is that if you have 2 column one is firstname and 2nd is lastname then you concating it by this query "select CONCAT(1stname, ' (' ,lastname,')') AS mixname from userdbase " then now you have to write this
this.ListBox1.DataTextField = "userdbase.mixname ";
this.ListBox1.DataValueField = "userdbase.mixname";
mixname is a virtual name that making to column as one at runtime.....

thanks..

put your last one code here.......that showing error

anytime buddy...

tried with this...??
void LoadGrid()
{
MySqlConnection sqlcon = new MySqlConnection(strConnString);
sqlcon.Open();
sqlcmd = new MySqlCommand("select CONCAT(1stname, ' (' ,lastname,')') AS mixname from userdbase ", sqlcon);
da = new MySqlDataAdapter(sqlcmd);
dt.Clear();
da.Fill(dt);
if (dt.Rows.Count > 0)
{

ListBox1.DataSource = dt;
ListBox1.DataTextField = "lastname";
ListBox1.DataBind();
}
}

what error showing??

what happen Software Engineer 892 ....??

but buddy the way you explain and openly demand for project source it too bad...dost then how can you make career in IT loosing easily confident on your own knowledge...

Tadit have any solution...for this?

just check out for syntax.....i think there is fault......because this is running proper in ma system...
Response.Write("<script LANGUAGE='JavaScript'>alert('Hiiiiiiii')</script>");

just copy and past it once....

ya friend its ma pleasure to to help you buddy....then still what you thinking got any solution for all browser...?

what it mean Orcun???

nothing that make you more familiar with it......its okk because now you got your answer

ya i think so...check on both events

what error showing...?

1st try on google.....its best to make your project live

ok ma pleasure but if you got your answer its good to make a click to "Accept Solution"....that help us to help you

dude this is possible with a specific programming platform without any platform how we integrate that requirement with file......why you are not using file security tools that could help you better.....

ma pleasure...thanks

with table width....not sound clear...explain it

something you worked on this...??

try this...

select * from Tb_SCh_TIme_Table where Sch_Date = '2/11/2013'

or

select * from Tb_SCh_TIme_Table where Sch_Date = "2/11/2013"

or check with change the format like....2-11-2013

something error showing...???

its universal dude...

still where your work reach...??or going to starting...?

window application or web application you want this??

dude for this 1st you have to try on google....but still i am working on your solution...just wait

any exception or error getting or not...like error code. HTTP 400...?

tell me one thing still the error that "Invalid attempt to call read when reader is closed" error occurring or not...?

Richard is CP only for non-technical solution??

nice knowledge by you thanks

finally got you happy with ma solution ......thank you boss its ma pleasure...ufff

thanks sir

hi Member 9644631 got any solution???

okk next time i will remember it.....don't want to make issue from now......happy to help without any problem that make unhappy to all co-ordinaters....be happy

always be ready to help......

hmm ma mean that i want to saw your complete code regarding to above line.......

good job onurag19

put these your code from starting...
sql = "select format(Holidaydate,'mmm dd yyyy') as Holdate, [Reason] from Tb_Delcared_Holidays where Holidaydate = '" + DGVCalendar.Rows[row].Cells[1].ToString() + "'";
oledr = GFun.ReadAcessSql(sql);
while (oledr.Read())
{
DGVCalendar.Rows[row].Cells[1].Style.BackColor = Color.Blue;
DGVCalendar.Rows[row].Cells[2].Value = oledr[0].ToString();
}

then lets look for error free...

thanks onurag19....

this is usually when you try to read by data reader that is no much active in code.....i think problem before it while(oledr.read())..try to put working datareader object....

what you want plz clarify it....

it mean you want to edit or delete a particular row of a grid view and for it the procedure is 1st right click on row then shows that above two menu(edit delete) of context...ok... tried any code..???

and First thing is to check with Way2SMS if they are exposing any Web Service for sending SMS. If so, get the details about the Web Service and consume it to send SMS.

hi buddy...for it to best googling......it helps you more...

can you exact clarify that what actually You doing...that help us to help you...

ok wait i will work on it then i told you the main fault...

ya ok but there also a delete link that helps you to remove solution from your end ..

its not good to put solution more the once .....be care full for next time...

thanks boss always ready to help...

this is basically in window application guys......1st understand the exactly need of code seeker....

ist confirm that what actually you want remove that or not....and best answer is to check it practically on the other copy of your project.....if work then good if not then very good because then you got your answer...so always believe himself

exam-ply have something that can more clear your question....???if yes then plz put here

from which process you want to follow it mean have any button click or like procedures ...?

okk

you want this in window application or ASP.Net...??

ya actually what you want to achieve...

ok i am getting that what actually you want to share with me.......but sorry i am not agree with you that i am repeating your words because if there need to parse method for string , int to string(because Console.readLine does not direct accept int value) then there is no way do define it with any else answer..my friend i am not taking your credential just to appreciate you.

just change visibility: hidden to visible......or like that(which is presenting in intellisence dialogue box)...

what is problem that need to down vote.....really embarrassing.........

thanks boss...make to ready for help....

are you using database....?

ya its our pleasure..........

Ya buddy there is several very good working tool that helps us exactly that we want to achieve like r-studio same as EASEUS Data Recovery Wizard Professional 5.5.1 that is current i am using when something have to recover and same it is free trial and more efficient.....so catch that actually i want to say...........there is many tool that can help us or may not help..........

Thanks bro...always ready to help...

i done this by wizard also don't get any code that helps like that....in wizard 1st to convert excel sheet into .CSV file and then restore it in sql...

there always has some alternates of every work.....don't forget it take it always in mind that help you to help us in better way...

my 5 boss....good to help as we can...

you want this by code or by wizard...?

its formatting problem...use correct for of your date like dd/mm/yyyy

its good to wrap your code in code tag but warping your problems in code tag....to bad...be careful next time.

Is you using real format of date time or just using simple string for list box...???

i see your above code...what is the problem with that...what error showing??

ya its ma pleasure and nice job Devang happy to help.........

now okk by v2

please more clarify that what actually you want to ask that can help us to help you...

ya Rumnha is right...there must be a control inside your group box becouse don't forget that Group Box is container control that content set of controls.

ya its ma pleasure boss.

friend this error generally occurs when we does not using proper data type for proper values from front end to back end........so plz once more revise your data types properly my doubt on your month column....

Reason for my vote of 5 \n I want this ...

ya Tadit is right just goggle 1st belive that helps you.

ya its possible with silverlight....

what you actually want...can more clarify....its for your better help

ya becoz of ite very good answer i read it many times then i uploded it....

as simple select statement like above mentioned for varchar SELECT @Hindi, and for nvarchar SELECT @nHindi....

i think there i got perfect answer thats why i posted here...........

once try this on every button click event...
Window win = new Window();
win.Show();

what error r you getting...???

ist i tried var but when look that still problam is stand then i use object...but thank sir it was some system error that was solved by restarting now running proper

ok sir...there is my code that run on radio button checked event....

if (radioButton2.Checked == true)
{
try
{
con = new MySqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["constr"];
con.Open();
string str = "select CONCAT(dname, ' (' ,relation,')') AS mixname from empdependents where pfno='" + sd.epfno + "' and (relation='wife' or relation='daughter' or relation='son' or relation='husband')";
da = new MySqlDataAdapter(str, con);
ds = new DataSet();
da.TableMappings.Add("table", "empdependentd");
da.Fill(ds, "empdependents");
this.listBox1.DataSource = this.ds.Tables["empdependentd"];
this.listBox1.DisplayMember = "empdependents.mixname ";
this.listBox1.ValueMember = "empdependents.mixname";
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}

}
and after it there is code by this i want to retrieve all items of 1st list box to another list box...
private void button6_Click(object sender, EventArgs e)
{
//listBox2.Items.AddRange(listBox1.Items);// 1st i tried this

foreach (object l in listBox1.Items)
{
listBox2.Items.Add(l);
}

}
but still showing 2nd list box that System.Data.DateRowView..

Sandeep Sir i have to do copy all items from one list box to another list box where as the 1st list box bind from a data source(database Column). there is a button like >> on btn's click event i tried many type of code like listbox2.items.addrange(listbox1.items); and make a foreach loop condition..........but still when run the project and click the >> btn then in 2nd list showing System.Data.DataRowView for each items.....i tried my top in ma project as well as on google there i got many solutions but they are not gives proper result on my condition....where is fault in binding database or in retrieving copy methodology .....

Reason for my vote of 4 \n this is that i searching. thanks

hi friend plz improve your question that can help us to help you....

for dynamic textbox u have to write the code-
if (!IsPostBack)
{
//bind textBox in placeholder its necessary for location
TextBox textBox = new TextBox();
textBox.ID = "TextBox1";
PlaceHolder1.Controls.Add(textBox);
}

but for above conditional query dear please describe those conditions clearly..

yes sir that's actually i want....sir i tried a lot but still i am not getting the result ....sir can u give me source code ......its the need that i want.

sir i don't want to save that images in database.....i think it makes database heavy....i want to save that images in root folder(bin-debug folder) or solution explorer's folder...

i think there is no such a method like Server.MapPath in c# window appllication....???

1st i am retriving file from opendialouge box and saving in into mysql database.....using this code.....

private string curFileName = null;
OpenFileDialog openDlg = new OpenFileDialog();

openDlg.Filter = "JPeg Image|*.jpg|Bitmap Image|*.bmp|Gif Image|*.gif";

string filter = openDlg.Filter;

openDlg.Title = "Open only Image Files";

if (openDlg.ShowDialog() == DialogResult.OK)
{

curFileName = openDlg.FileName;

textBox2.Text = curFileName;
}
FileStream fs = new FileStream(curFileName,

FileMode.OpenOrCreate, FileAccess.Read);
int file = (int)fs.Length;
byte[] rawData = new byte[file];

fs.Read(rawData, 0, (int)file);

fs.Close();
string str = "select * from Doc";
if (con.State != ConnectionState.Open)
con.Open();
MySqlDataAdapter da = new MySqlDataAdapter(str,con);
MySqlCommandBuilder mcb = new MySqlCommandBuilder(da);
DataSet ds = new DataSet("Doc");
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
da.Fill(ds,"Doc");
DataRow row=ds.Tables["Doc"].NewRow();
row["pfno"] = label7.Text;
row["depname"] = label8.Text;
row["docname"] = comboBox1.Text;
row["docdisc"] = textBox1.Text;
row["addedby"] = sd.uname;
row["depdoc"] =rawData;
ds.Tables["Doc"].Rows.Add(row);
da.Update(ds,"Doc");
if(con!=null)
{
if(con.State==ConnectionState.Open)
{
con.Close();
con.Dispose();
}
MessageBox.Show("Document Saved Successfully");
}
_____________________________________________________________________________________
it is running succesfully for saving but now the main fault when i am retriving that ID specific image on winform using this code....

try
{
string str1 = "select * from doc where pfno='" + label7.Text + "' and depname='"+label8.Text+"'";
con.Open();
MySqlCommand cmd = new MySqlCommand(str1, con);
MySqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
string name = data.GetString(data.GetOrdinal("depname"));
" error Ocurring on this line below and error is Invalid Cast Exception(Object must implement IConvertible.)"
int filesize = data.GetInt32(data.GetOrdinal("depdoc"));
byte[] rawData = new byte[filesize];
data.GetBytes(data.GetOrdinal("depdoc"), 0, rawData, 0, filesize);
FileStream fs = new FileStream(name, FileMode.Create, FileAccess.Write);
fs.Write(rawData, 0, filesize);
fs.Close();
pictureBox1.Image = new Bitmap(name);
}

}
catch(Exception ex)
{
MessageBox.Show("Document Test " + ex);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();

}
so sir now any help???

1st i am retriving file from opendialouge box and saving in into mysql database.....using this code.....

private string curFileName = null;
OpenFileDialog openDlg = new OpenFileDialog();

openDlg.Filter = "JPeg Image|*.jpg|Bitmap Image|*.bmp|Gif Image|*.gif";

string filter = openDlg.Filter;

openDlg.Title = "Open only Image Files";

if (openDlg.ShowDialog() == DialogResult.OK)
{

curFileName = openDlg.FileName;

textBox2.Text = curFileName;
}
FileStream fs = new FileStream(curFileName,

FileMode.OpenOrCreate, FileAccess.Read);
int file = (int)fs.Length;
byte[] rawData = new byte[file];

fs.Read(rawData, 0, (int)file);

fs.Close();
string str = "select * from Doc";
if (con.State != ConnectionState.Open)
con.Open();
MySqlDataAdapter da = new MySqlDataAdapter(str,con);
MySqlCommandBuilder mcb = new MySqlCommandBuilder(da);
DataSet ds = new DataSet("Doc");
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
da.Fill(ds,"Doc");
DataRow row=ds.Tables["Doc"].NewRow();
row["pfno"] = label7.Text;
row["depname"] = label8.Text;
row["docname"] = comboBox1.Text;
row["docdisc"] = textBox1.Text;
row["addedby"] = sd.uname;
row["depdoc"] =rawData;
ds.Tables["Doc"].Rows.Add(row);
da.Update(ds,"Doc");
if(con!=null)
{
if(con.State==ConnectionState.Open)
{
con.Close();
con.Dispose();
}
MessageBox.Show("Document Saved Successfully");
}
_____________________________________________________________________________________
it is running succesfully for saving but now the main fault when i am retriving that ID specific image on winform using this code....

try
{
string str1 = "select * from doc where pfno='" + label7.Text + "' and depname='"+label8.Text+"'";
con.Open();
MySqlCommand cmd = new MySqlCommand(str1, con);
MySqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
string name = data.GetString(data.GetOrdinal("depname"));
" error Ocurring on this line below and error is Invalid Cast Exception(Object must implement IConvertible.)"
int filesize = data.GetInt32(data.GetOrdinal("depdoc"));
byte[] rawData = new byte[filesize];
data.GetBytes(data.GetOrdinal("depdoc"), 0, rawData, 0, filesize);
FileStream fs = new FileStream(name, FileMode.Create, FileAccess.Write);
fs.Write(rawData, 0, filesize);
fs.Close();
pictureBox1.Image = new Bitmap(name);
}

}
catch(Exception ex)
{
MessageBox.Show("Document Test " + ex);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();

}
anyone have solid answer....??

i want to retrive image from mysql db(a colume name image datatype longblob) onto my winapp form in the form of int.....

then finally what to do...beside this query have any other option to convert longblob into int in c#???