|
plese any one help me ,
i doing work on asp.net ,ms access database but when doing programing for wieght and price wise dearch data then it gave error .data type mismatch ,
how it solve my code is
if (chkWeight.Checked == true)
{
if (strMetal != "" && strType != "" && FromWieght != 0 && ToWieght == 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght >='" + FromWieght + "' and MetalID IN (select MetalID from MetalMaster where Name='" + strMetal + "') and TypeID IN (select TypeID from Type where Name='" + strType + "')", myAccessConnection);
}
else if (strMetal != "" && strType != "" && FromWieght == 0 && ToWieght != 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght <='" + ToWieght + "' and MetalID IN (select MetalID from MetalMaster where Name='" + strMetal + "') and TypeID IN (select TypeID from Type where Name='" + strType + "')", myAccessConnection);
}
else if (strMetal != "" && strType == "" && FromWieght != 0 && ToWieght != 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght beween '" + FromWieght + "' and '" + ToWieght + "' and MetalID IN (select MetalID from MetalMaster where Name='" + strMetal + "')", myAccessConnection);
}
else if (strMetal == "" && strType != "" && FromWieght != 0 && ToWieght != 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght beween '" + FromWieght + "' and '" + ToWieght + "' and TypeID IN (select TypeID from Type where Name='" + strType + "')", myAccessConnection);
}
else if (strMetal!="" && strType!="" && FromWieght!=0 && ToWieght!=0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght beween '" + FromWieght + "' and '" + ToWieght + "' and TypeID IN (select TypeID from Type where Name='" + strType + "') and MetalID IN (select MetalID from MetalMaster where Name='" + strMetal + "')", myAccessConnection);
}
else if (FromWieght == 0 && ToWieght != 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght <='" + ToWieght + "' ", myAccessConnection);
}
else if (FromWieght != 0 && ToWieght == 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght >= '" + FromWieght + "'", myAccessConnection);
}
else if (FromWieght != 0 && ToWieght != 0)
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and Wieght between '" + FromWieght + "' and '" + ToWieght + "'", myAccessConnection);
//// cmd1.Parameters = CommandType.Text;
// OleDbParameter From_Wieght = new OleDbParameter("@FromWieght", OleDbType.Numeric);
// From_Wieght.Value = FromWieght;
// cmd1.Parameters.Add(From_Wieght);
// OleDbParameter To_Wight = new OleDbParameter("@ToWight", OleDbType.Numeric);
// To_Wight.Value =ToWieght ;
// cmd1.Parameters.Add(To_Wight);
}
}
else if (strMetal != "Select Item" && strType != "Select Item")
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and TypeID IN (select TypeID from Type where Name='" + strType + "') and MetalID IN (select MetalID from MetalMaster where Name='" + strMetal + "')", myAccessConnection);
}
else if (strMetal == "Select Item" && strType != "Select Item")
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and TypeID IN (select TypeID from Type where Name='" + strType + "')", myAccessConnection);
}
else if (strMetal != "Select Item" && strType == "Select Item")
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID and MetalID IN (select MetalID from MetalMaster where Name='" + strMetal + "')", myAccessConnection);
}
else
{
cmd1 = new OleDbCommand("select * from DtlItem where CategoryID=@CategoryID", myAccessConnection);
//OleDbParameter From_Wieght = new OleDbParameter("@FromWieght", OleDbType.Integer);
//From_Wieght.Value = 312434;
//cmd1.Parameters.Add(From_Wieght);
}
int CatID = Convert.ToInt16(ViewState["CatID"]);
// cmd1.Parameters = CommandType.Text;
OleDbParameter Cat_ID = new OleDbParameter("@CategoryID", OleDbType.Integer);
Cat_ID.Value = CatID;
cmd1.Parameters.Add(Cat_ID);
OleDbDataAdapter adp = new OleDbDataAdapter(cmd1);
DataSet ds = new DataSet();
myAccessConnection.Open();
|
|
|
|
|
Hi
I wrote these code for changing the language of my site.the default language of site is Farsi,and i put two link button in master page for switching the language , and i have two css ,one for Farsi and one for English.when the page load and when i click on en link button ,the language change but the css doesn't change ,I don't know why?
in all page except master page i wrote:
protected override void InitializeCulture()
{
if (Session["lang"] != null)
{
string selectedlang = Session["lang"].ToString();
UICulture = selectedlang;
Culture = selectedlang;
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(selectedlang);
Thread.CurrentThread.CurrentUICulture = new CultureInfo(selectedlang);
}
base.InitializeCulture();
}
in masterpage in click event of link buttons
protected void LinkButton1_Click(object sender, EventArgs e)
{
Session["lang"] = "en-US";
Server.Transfer(Request.Url.PathAndQuery, false);
type='text/css' />";
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
Session["lang"] = "fa-IR";
Server.Transfer(Request.Url.PathAndQuery, false);
type='text/css' />";
}
and in page load of master page:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["lang"] == null)
{
this.Literal1.Text = "<link href="fa.css" rel="stylesheet" type="text/css" />";
}
else
if (Session["lang"].ToString() == "en-US")
{
this.Literal1.Text = "<link href="fa.css" rel="stylesheet" type="text/css" />";
}
else
if (Session["lang"].ToString() == "fa-IR")
{
this.Literal1.Text = "<link href="fa.css" rel="stylesheet" type="text/css" />";
}
}
asp:Literal ID="Literal1" runat="server">
|
|
|
|
|
strawberrysh wrote: if (Session["lang"] == null)
{
this.Literal1.Text = "";
}
else
if (Session["lang"].ToString() == "en-US")
{
this.Literal1.Text = "";
}
else
if (Session["lang"].ToString() == "fa-IR")
{
this.Literal1.Text = "";
}
Because your calling same CSS class fa.css for each condition
Where is the another Css ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
Hy,
I m tryng to retrive image from database. the code dosent giv ane run time error but the image is not displayed
Response.ContentType = "image/jpeg";
Stream strm = ShowEmpImage(8);
byte[] buffer = new byte[4096];
int byteSeq = strm.Read(buffer, 0, 4096);
strm.Read(buffer, 0, 4096);
Response.BinaryWrite(buffer);
}
public Stream ShowEmpImage(int a)
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = "Data Source=SERVER;Initial Catalog=image;Persist Security Info=True;User ID=sa;password="";
connection.Open();
string sql = "SELECT picture FROM image where id='" + a + "' ";
SqlCommand cmd = new SqlCommand(sql, connection);
object img = cmd.ExecuteScalar();
return new MemoryStream((byte[])img);
}
plz help
|
|
|
|
|
Just a little pointer.
Its better to store just the image location in the database rather than the whole image as it tends to bloat the database.
|
|
|
|
|
My name is santhosh. i jsut started my Dot Net Class. can you send me a sample project about the student details.I want to know how to update, edit and cancel the details in a grid view .I using Microsoft Access as data base.
MY PROJECt DETAILS
default.aspx
...........
Name txtbox
Age txtbox
Address Txtbox
Email TxtBox
Gender radio btn male, raduiobtn female
Qualification chkbox Bsc,Chkbox MSc,chkboxBe
Save Button
................................................................................
default2.aspx
Name txtbox
Age txtbox
Address Txtbox
Email TxtBox
Gender radio btn male, raduiobtn female
Qualification chkbox Bsc,Chkbox MSc,chkbox BE
Update button & cancel button
.......................................................................................
Grid.aspx
Grid view
...............................................................................
Looking forward hearing from you soon
|
|
|
|
|
This sounds like you asking for somebody to do your homework for you...
Normally, you attempt to do the project yourself, and when you have problems with a specific part, you ask for help (or search Google).
|
|
|
|
|
santhoshasokan wrote: I want to know how to update, edit and cancel the details in a grid view
In which case I suggest either a good book or use Google. This forum does not do homework - there is no point, if someone here did it you would not learn anything, and I may end up fixing your crap code.
So try on your own and post any SPECIFIC questions for assistance.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi
i my website i m using a user control,which contains 3 dropdown list boxes and i set postback property for dropdownlist as true.when i select an item in the dropdown list then the user control disappears
plz help me
how to overcome this problem
i m adding the user control at runtime
thanks in advance
vijay kumar D
|
|
|
|
|
Can you post here block of code in which method you are adding the User Control ?
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
hi
i have datagrid where i display data and i have set AutoGenerateDeleteButton="true" AutoGenerateEditButton="true".when i click edit on gridview once it doesn't show upadte and cancel,it only shows when i click for second time.
here is my code
protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing
GridView1.EditIndex = e.NewEditIndex
CType(GridView1.Rows(e.NewEditIndex).FindControl("ddlgvclients"), DropDownList).Enabled = True
CType(GridView1.Rows(e.NewEditIndex).FindControl("ddlgvregions"), DropDownList).Enabled = True
CType(GridView1.Rows(e.NewEditIndex).FindControl("ddlgvservices"), DropDownList).Enabled = True
End Sub
Mamphekgo
|
|
|
|
|
Hi
I have a query which is ran from my aspx page.
The query is ordered by a field which contains the letters 'y' and 'n'
Now when the letter is not a capital it orders fine, but when the letter is a capital it doesnt order properly.
Why is this?
any help would do.
thanks
|
|
|
|
|
always make it to same case, means either Upper case or Lower case before you order by in the query.
Abhishek Sur
|
|
|
|
|
Do you mean in the query? How would I do this?
Or do you mean manually change all data? That would be an extreme solution!
|
|
|
|
|
Yes.. Its in query...
no need to do this manually...
But if you like in code ... this would not be a big deal. Have you used LINQ. ..
Abhishek Sur
|
|
|
|
|
hi
give like this
order by upper(<colname>)
T.Balaji
|
|
|
|
|
hi all,
ive an issue..i created a web application..The link is like this http://servername/abc/login.aspx. In the login page ive written the following javascript function
var win = open ('Login.aspx', 'login','fullscreen=yes, scrollbars=auto');
to maximise the page fully thereby hiding the URL.Its working fine in the local servers(dev,beta and test server).But when i deploy it in the production server(internet)in the client place,the URL with the above link becomes apparent causing concern.I think there is something to do with the security settings of the browser.But tats gonna b a herculean task to go and change in each and every client's pc..Can any1 help me find a best solution for this issue?Thanks in advance..
Note:This happnens in IE 7.0 only
T.Balaji
|
|
|
|
|
Don't even bother. If it is such a problem that users know the URL, then you are doing osmething wrong.
|
|
|
|
|
hi all,
With reference to my earlier query,i found out that the security settings is the main issue.It works 5n in IE6.0 irrespective of the security settings(whethr medium,low-medium or high) whereas in IE7.0 if we change the security settings to medium-high the address bar and the title bar becomes visible which causes concern.Can any one tell me whethr it is possible to control the security settings via coding?if yes then how?
T.Balaji
|
|
|
|
|
balaji.t wrote: Can any one tell me whethr it is possible to control the security settings via coding
Good grief - of course not!! Just imagine if any web site you visited could control the security settings of your browser!
Try thinking before you ask...
|
|
|
|
|
Thanx phil..i knew that tis not possible..tats y i made anothr statement in my earlier mail for other alternatives?k tell me whether is it psble to get/retrieve the security settings via coding and give an alert for the user to change his browser security settings to Low and proceed?
T.Balaji
|
|
|
|
|
hey ,
can I use both atlas:ScriptManager and asp:scriptmanager in the same form
I need to use both atlas extenders and ajax extenders which requires scriptmanagers in the same form.
Thanks in advance
|
|
|
|
|
generally we cant have multiple script managers in a single page.
I dont know exactly .. but I dont think it is a good idea for using one Beta product with the Original one ....
Abhishek Sur
|
|
|
|
|
Yeah I know about now allowing multiple script managers in a single page.
I just tought that you can do it if it is from different toolkits.
Ill look for another workaround
thanks
|
|
|
|
|
Dear Friend,
I have a query regarding the client side printing, i want to print my report at client side without the Prompt of Window.Print() form can it possible??? using javascript or server side scripting.
Thanks and Regards
Sasmi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
