|
thanks for the reply, i changed it to jpg and it worked!
cheers!
|
|
|
|
|
I am working on a aspx page that allows a user to change the look and feel(like iGoogle). I want to save each users profile into an XML file.
Can anyone please help!
Thanks in advance!
|
|
|
|
|
|
Cool man, thanks and shame on me but ya thanks for your help 
|
|
|
|
|
You are welcome! and I'm sorry for being a bit grumpy, my day sucks today
Btw, I think you really should try that profile provider mentioned, it is better than plain XML file read/write access and it is also integrated into you object model, in your code you can access your Profile properties directly.
http://msdn.microsoft.com/en-us/library/system.web.profile.profilebase.aspx[^]
|
|
|
|
|
hello every buddy
i am creating and deleting folder in my site.
but my problem is that when ever i delete folder then it work only in Mozilla Firefox not in IE. and 2nt problem is that after deleting folder it logout me like i build the project.
my code for delete folder is below-
string folderpath = HttpContext.Current.Server.MapPath("folder path");
System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(folderpath);
if (di.Exists)
{
di.Delete(true);
}
Rajeev Kr. Sharma
VRI Software Pvt.Ltd.
New Delhi India
HumOnline.com
Stay Connected
|
|
|
|
|
did you mean folder delete only at the Mozila ?????????? 
|
|
|
|
|
yes
Rajeev Kr. Sharma
VRI Software Pvt.Ltd.
New Delhi India
HumOnline.com
Stay Connected
|
|
|
|
|
so so intersting because i think it is server side code and not depend on the browser
|
|
|
|
|
i am also surprise.
Rajeev Kr. Sharma
VRI Software Pvt.Ltd.
New Delhi India
HumOnline.com
Stay Connected
|
|
|
|
|
The submitted data should also be examined if there is a faulty escaped (encoding).
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi all,
this error occure in my function:not all code paths return a value
public bool ValidateNewUser(string strAlias, string strFirst, string strLast)
{
SqlConnection MyConn = new SqlConnection(ConfigurationSettings.AppSettings["MyOnlineShoppingConnectionString2"]);
SqlCommand MyCmd = new SqlCommand("sp_CheckForDuplicates", MyConn);
MyCmd.CommandType = CommandType.StoredProcedure;
SqlParameter objParam1;
SqlParameter objParam2;
SqlParameter objParam3;
SqlParameter objReturnParam;
objParam1 = MyCmd.Parameters.Add("@UserName", SqlDbType.VarChar);
objParam2 = MyCmd.Parameters.Add("@FirstName", SqlDbType.VarChar);
objParam3 = MyCmd.Parameters.Add("@LastName", SqlDbType.VarChar);
objReturnParam = MyCmd.Parameters.Add("@Duplicates", SqlDbType.Int);
objReturnParam.Direction = ParameterDirection.ReturnValue;
objParam1.Value = strAlias;
objParam2.Value = strFirst;
objParam3.Value = strLast;
try
{
if (MyConn.State == ConnectionState.Closed)
{
MyConn.Open();
MyCmd.ExecuteNonQuery();
}
if (Convert.ToInt32(objReturnParam.Value )>0)
{
lblResult.Text = "UserName already exists or you are already a registered user!";
return false;
}
else
{
return true;
}
MyConn.Close();
}
catch (Exception ex)
{
lblError.Text = "Error Connecting to Database!";
}
}
i have two return value but how i can define these for all function?
Thank You,
Hoda
|
|
|
|
|
public bool ValidateNewUser(string strAlias, string strFirst, string strLast)
so you must return a value in the all way
add "return false" to the end of function or remove the else
if (Convert.ToInt32(objReturnParam.Value )>0)
{
lblResult.Text = "UserName already exists or you are already a registered user!";
return false;
}
return true;
|
|
|
|
|
First, be sure you close the connection all the time, in your code, the line MyConn.Close(); is never called!
And the reason for the error is, that you don't return anything when there is an exception. you need to have a return statement in your catch block, however, cleaner solution would be to have a finally block after catch, where you return a value
|
|
|
|
|
I created a form view in asp.net for a data entry web page. User inputs data which is supposed to get inserted into my MySql database in a existing database. but when I try the following code, I get the following error:
System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'product_id, 'Button Up'product_name, 'shirts'product_desc, 1000tot_qty, 36tot_ca' at line 2
This is the script I am running in my .aspx file.
InsertCommand="insert into product(product_id, product_name, product_desc, tot_qty, tot_cartons, cost, tot_colors,qty_per_carton, arrival_date, custom_clearedby, ship_mode)
values( ?product_id, ?product_name, ?product_desc, ?tot_qty, ?tot_cartons, ?cost, ?tot_colors,?qty_per_carton, ?arrival_date, ?custom_clearedby, ?ship_mode);
I would really appreciate any help/insight.
Thanks in advance
modified on Monday, May 19, 2008 12:17 PM
|
|
|
|
|
When trouble shooting commands like this, it always helps to show all of the relevant code (e.g. paramaters).
Each paramater "?some_param" should be assigned a value, you did not post this part of the code. Also, the paramaters should be added in the same order they are used in you MySql statement. I also don't see you closing the string, however this might be a copy/paste typo. Nonetheless, complete code is essential especially when this appears to be some type of string problem.
Based on your posted example, they should look like this:
mysqlCmd.Parameters.AddWithValue("?product_id", "some_value")
mysqlCmd.Parameters.AddWithValue("?product_name", "some_value")
mysqlCmd.Parameters.AddWithValue("?product_desc", "some_value")
etc..
Hope this helps!
|
|
|
|
|
I want to Format a value in report..Iam using component designer as report tool..
xmlDoc.Load(strPath & "/Reports/Analysis Reports/ReservedItemsSummary.xml")
xmlDoc.GetElementsByTagName("pssl_unitprice").Item(0).InnerXml.Format = "#,##0.000"
this syntax is wrong..
can any one help how to format the value of field(pssl_unitprice) from xml file...
I want to format the value 0.000 format
|
|
|
|
|
Hi,
I made a class file , which is being used to interact with the database.
Can i get ur views to improve it.
I m doing all the rollback /commit transaction at the stored procedure level.
According to me this is my Best code ever written in my carrier.
Here is the code.....
using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
<br />
namespace MyClasses<br />
{<br />
public class AddParameters<br />
{ <br />
public AddParameters[] p;<br />
internal SqlParameter param = new SqlParameter();<br />
public AddParameters()<br />
{<br />
p = new AddParameters[1];<br />
}<br />
public void ParameterFunction<T>(string ParameterName, T _ParameterValue, ParameterDirection ParameterDirection, SqlDbType ParameterType)<br />
{<br />
if (p[p.Length - 1] != null)<br />
{<br />
AddParameters[] temp = new AddParameters[p.Length];<br />
p.CopyTo(temp, 0);<br />
p = new AddParameters[p.Length + 1];<br />
for (int i = 0; i < p.Length - 1; i++)<br />
{<br />
p[i] = temp[i];<br />
}<br />
p[p.Length - 1] = new AddParameters();<br />
p[p.Length - 1].param.ParameterName = ParameterName;<br />
p[p.Length - 1].param.Value = _ParameterValue;<br />
p[p.Length - 1].param.Direction = ParameterDirection;<br />
p[p.Length - 1].param.SqlDbType = ParameterType;<br />
}<br />
else<br />
{<br />
p[0] = new AddParameters();<br />
p[0].param.ParameterName = ParameterName;<br />
p[0].param.SqlValue = _ParameterValue;<br />
p[0].param.Direction = ParameterDirection;<br />
p[0].param.SqlDbType = ParameterType;<br />
}<br />
}<br />
}<br />
<br />
public class DatabaseInteraction
{<br />
AddParameters ad = null;<br />
SqlConnection con = null;<br />
private string connectionstring = "";<br />
private string StoredProcedure = "";<br />
SqlCommand cmd = null;<br />
DataSet ds = null;<br />
SqlDataAdapter sqlad = null;<br />
public void AddParameters<T>(string Parametername, T Parametervalue, ParameterDirection ParameterDirection, SqlDbType type)<br />
{<br />
}<br />
public DatabaseInteraction()<br />
{<br />
<br />
}<br />
public static string ChangeDateFormat(string t)<br />
{<br />
string dat = "";<br />
DateTime datformat;<br />
if (DateTime.TryParse(t, out datformat))<br />
{<br />
dat = datformat.ToString("dd/MM/yyyy");<br />
return dat;<br />
}<br />
return dat;<br />
}<br />
public DatabaseInteraction(string constr)<br />
{<br />
connectionstring = constr;<br />
ad = new AddParameters();<br />
} <br />
<br />
private string Connect(out SqlConnection con)<br />
{<br />
try<br />
{<br />
con = new SqlConnection(connectionstring);<br />
con.Open();<br />
return "";<br />
}<br />
<br />
catch (Exception ex)<br />
{<br />
con = null;<br />
return ex.Message.ToString();<br />
}<br />
}<br />
<br />
public string StoredProcedureName<br />
{ <br />
get<br />
{<br />
return StoredProcedure;<br />
}<br />
set<br />
{<br />
StoredProcedure = value;<br />
}<br />
}<br />
public string BindingWithControl(Control ctl, string ValueMember, string DisplayMember)<br />
{<br />
string message = Connect(out con);<br />
if (message == "")<br />
{<br />
message = GetDataSet(con, ref ds);<br />
if (message == "")<br />
{<br />
BindControl(ctl, ds, DisplayMember, ValueMember);<br />
con.Close();<br />
return "";<br />
}<br />
else<br />
{<br />
con.Close();<br />
return message;<br />
}<br />
}<br />
else<br />
{<br />
con.Close();<br />
return message;<br />
}<br />
}<br />
<br />
public void BindControl(Control ctl, DataSet ds, string DisplayMember, string ValueMember)<br />
{<br />
if (ctl is RadioButtonList)<br />
{<br />
RadioButtonList chk;<br />
chk = (RadioButtonList)ctl;<br />
chk.DataTextField = DisplayMember;<br />
chk.DataValueField = ValueMember;<br />
chk.DataSource = ds.Tables[0];<br />
chk.DataBind();<br />
}<br />
if (ctl is CheckBoxList)<br />
{<br />
CheckBoxList chk;<br />
chk = (CheckBoxList)ctl;<br />
chk.DataTextField = DisplayMember;<br />
chk.DataValueField = ValueMember;<br />
chk.DataSource = ds.Tables[0];<br />
chk.DataBind();<br />
}<br />
if (ctl is DropDownList)<br />
{<br />
DropDownList ddl;<br />
ddl = (DropDownList)ctl;<br />
if (DisplayMember != "")<br />
{<br />
ddl.DataTextField = DisplayMember;<br />
}<br />
if (ValueMember != "")<br />
{<br />
ddl.DataValueField = ValueMember;<br />
} <br />
ddl.DataSource = ds;<br />
ddl.DataBind();<br />
}<br />
if (ctl is GridView)<br />
{<br />
GridView gv;<br />
gv = (GridView)ctl;<br />
if (ds.Tables.Count == 0)<br />
{<br />
return;<br />
}<br />
gv.ID = ctl.ID;<br />
gv.DataSource = ds;<br />
gv.DataBind();<br />
}<br />
if (ctl is Repeater)<br />
{<br />
Repeater gv;<br />
gv = (Repeater)ctl;<br />
if (ds.Tables.Count == 0)<br />
{<br />
return;<br />
}<br />
gv.ID = ctl.ID;<br />
gv.DataSource = ds;<br />
gv.DataBind();<br />
}<br />
if (ctl is DataList)<br />
{<br />
DataList gv;<br />
gv = (DataList)ctl;<br />
if (ds.Tables.Count == 0)<br />
{<br />
return;<br />
}<br />
gv.ID = ctl.ID;<br />
gv.DataSource = ds;<br />
gv.DataBind();<br />
}<br />
}<br />
<br />
public string GetDataSet(SqlConnection con, ref DataSet ds)<br />
{<br />
try<br />
{<br />
<br />
cmd = new SqlCommand();<br />
cmd.Connection = con;<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
cmd.CommandText = StoredProcedure;<br />
if (ad != null)<br />
{<br />
if (ad.p[0] != null)<br />
{<br />
if (ad.p.Length != 0)<br />
ReturnSqlCommand(ref cmd, ad.p);<br />
}<br />
}<br />
ds = new DataSet();<br />
<br />
sqlad = new SqlDataAdapter(cmd);<br />
sqlad.Fill(ds);<br />
if (ad.p[0] == null)<br />
{<br />
return "";<br />
}<br />
for (int count = 0; count < ad.p.Length; count++)<br />
{<br />
if (ad.p[count] == null)<br />
continue;<br />
if (ad.p[count].param.Direction == ParameterDirection.Output)<br />
{<br />
ad.p[count].param.SqlValue = cmd.Parameters[count].Value.ToString();<br />
}<br />
if (ad.p[count].param.Direction == ParameterDirection.InputOutput)<br />
{<br />
ad.p[count].param.SqlValue = cmd.Parameters[count].Value.ToString();<br />
}<br />
} <br />
return "";<br />
}<br />
catch (Exception ex)<br />
{<br />
return ex.Message.ToString(); <br />
}<br />
}<br />
<br />
private SqlCommand ReturnSqlCommand(ref SqlCommand cmd, AddParameters[] db)<br />
{<br />
for (int count = 0; count < db.Length; count++)<br />
{<br />
if (db[count].param.Direction == ParameterDirection.Input)<br />
{<br />
cmd.Parameters.AddWithValue(db[count].param.ParameterName, db[count].param.SqlDbType).Value = db[count].param.SqlValue;<br />
cmd.Parameters[count].SqlDbType = db[count].param.SqlDbType;<br />
}<br />
if (db[count].param.Direction == ParameterDirection.Output)<br />
{<br />
cmd.Parameters.AddWithValue(db[count].param.ParameterName, db[count].param.SqlDbType);<br />
cmd.Parameters[count].SqlDbType = db[count].param.SqlDbType;<br />
cmd.Parameters[count].Direction = ParameterDirection.Output;<br />
}<br />
if (db[count].param.Direction == ParameterDirection.InputOutput)<br />
{<br />
cmd.Parameters.AddWithValue(db[count].param.ParameterName, db[count].param.SqlDbType);<br />
cmd.Parameters[count].SqlDbType = db[count].param.SqlDbType;<br />
cmd.Parameters[count].Direction = ParameterDirection.InputOutput;<br />
cmd.Parameters[count].Size = 3000;<br />
}<br />
}<br />
return cmd;<br />
}<br />
<br />
public string returnScalarData()<br />
{<br />
SqlCommand cmd = new SqlCommand();<br />
SqlConnection con;<br />
Connect(out con);<br />
DataSet ds = new DataSet();<br />
cmd.Connection = con;<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
cmd.CommandText = StoredProcedure;<br />
if (ad != null)<br />
{<br />
if (ad.p != null)<br />
{<br />
if (ad.p.Length != 0)<br />
ReturnSqlCommand(ref cmd, ad.p);<br />
}<br />
<br />
}<br />
if (cmd.ExecuteScalar() == null)<br />
return null;<br />
else<br />
return cmd.ExecuteScalar().ToString().Trim();<br />
}<br />
<br />
public DataSet returndataset()<br />
{<br />
SqlCommand cmd = new SqlCommand();<br />
SqlConnection con;<br />
Connect(out con);<br />
DataSet ds = new DataSet();<br />
cmd.Connection = con;<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
cmd.CommandText = StoredProcedure;<br />
if (ad != null)<br />
{<br />
if (ad.p[0] != null)<br />
{<br />
if (ad.p.Length != 0)<br />
ReturnSqlCommand(ref cmd, ad.p);<br />
}<br />
}<br />
sqlad = new SqlDataAdapter(cmd);<br />
sqlad.Fill(ds);<br />
sqlad = null;<br />
return ds;<br />
}<br />
}<br />
}
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Pankaj Garg wrote: written in my carrier
carrier 
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
i meant career .Sorry for the spellings
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
No problem. But a quick spell check would always help before posting across to a wider audience and community.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Pankaj Garg wrote: string GetDataSet(SqlConnection con, ref DataSet ds)
Function is named GetDataSet() and it returns a string . Also I don't think ref is not needed here as DataSet is a class and passed always as reference.
Pankaj Garg wrote: catch (Exception ex)
{
return ex.Message.ToString();
}
}
This is bad. You should catch specific exception types, do cleanup and re-throw it. Also you are not disposing instances. You know most of the classes used here has a Dispose() method, call that when you finish using the instance. This will allow instance memory reclaiming.
|
|
|
|
|
Pankaj Garg wrote: According to me this is my Best code ever written in my carrier.
Change career! Its some of the worst data abstraction code Ive seen in my career!
eg/ what the hell is all this about (note: p is set to an array with 1 element):
Pankaj Garg wrote: public void ParameterFunction<T>(string ParameterName, T _ParameterValue, ParameterDirection ParameterDirection, SqlDbType ParameterType)
{
if (p[p.Length - 1] != null)
{
AddParameters[] temp = new AddParameters[p.Length];
p.CopyTo(temp, 0);
p = new AddParameters[p.Length + 1];
for (int i = 0; i < p.Length - 1; i++)
{
p[i] = temp[i];
}
p[p.Length - 1] = new AddParameters();
p[p.Length - 1].param.ParameterName = ParameterName;
p[p.Length - 1].param.Value = _ParameterValue;
p[p.Length - 1].param.Direction = ParameterDirection;
p[p.Length - 1].param.SqlDbType = ParameterType;
}
else
{
p[0] = new AddParameters();
p[0].param.ParameterName = ParameterName;
p[0].param.SqlValue = _ParameterValue;
p[0].param.Direction = ParameterDirection;
p[0].param.SqlDbType = ParameterType;
}
}
}
and this is just car-crash stuff. I shouldnt look, but at the same time I cant look away
public string GetDataSet(SqlConnection con, ref DataSet ds)
{
try
{
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = StoredProcedure;
if (ad != null)
{
if (ad.p[0] != null)
{
if (ad.p.Length != 0)
ReturnSqlCommand(ref cmd, ad.p);
}
}
ds = new DataSet();
sqlad = new SqlDataAdapter(cmd);
sqlad.Fill(ds);
if (ad.p[0] == null)
{
return "";
}
for (int count = 0; count < ad.p.Length; count++)
{
if (ad.p[count] == null)
continue;
if (ad.p[count].param.Direction == ParameterDirection.Output)
{
ad.p[count].param.SqlValue = cmd.Parameters[count].Value.ToString();
}
if (ad.p[count].param.Direction == ParameterDirection.InputOutput)
{
ad.p[count].param.SqlValue = cmd.Parameters[count].Value.ToString();
}
}
return "";
}
catch (Exception ex)
{
return ex.Message.ToString();
}
}
Tell me, how do you call a stored procedure with more than 1 parameter?
modified on Monday, May 19, 2008 8:31 AM
|
|
|
|
|
Hello There,
I developed a website and uploaded it to the web but when i'm trying it it shows me the Error "Compiler Error Message: CS0246: The type or namespace name ...." .
When i want to add new class to the project Visual Studio 2005 recomended to add it under APP_CODE folder and i did.
i uploaded the website after compiling it using the copy web site method from website menu >> Copy Website option and then i used ftp manager to uploaded .
the code is running very well on my machine but online no.
i don't have any dll for these classes so i can add the referrence it's just normal .cs classes .
i don't know should i add anything to the web.config or modify something in the code ?
Asaad Mamoun
|
|
|
|
|
Hi all,
I am building one application where i want to do folowing
1) Open popup on button click
2) Pop up contains name textbox and search button and datagrid.
3) user type name in textbox and search result will comre in datagrid
I used modal popup ajax control (AnimationExtender)
New pop is properly loding with all controls but when i clicked on search button popup window automaticaly close.
I am not getting how to handel this?
so plz help me if anyone knows soln....
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
