|
Can anyone please help me with the following exception.
Exception Type: System.Data.SyntaxErrorException
-----------------------------------------------------------
Message: Syntax error: Missing operand after 'V' operator.
-----------------------------------------------------------
Data: System.Collections.ListDictionaryInternal
TargetSite: System.Data.ExpressionNode Parse()
HelpLink: NULL/Undefined
Source: System.Data
what is a 'V' operator ?? how shld i proceed about fixing this ??
thanks
|
|
|
|
|
Can you share the details on what you are doing and the section which is raising this error?
|
|
|
|
|
Can you please provide code snippet of the lines where you are getting this error.
|
|
|
|
|
Hi.. thnks for the reply.. the issue is - i am not able to reproduce the same exception in my local.. i am in tech support for this application and its been done by a client in live environment.. i can share u the stack trace but wont be of much use i guess.. if u can giv me a rough reason of occurance this error..i'l debug and try to find the point of cause..
|
|
|
|
|
i'l get u the code snippet..
public void SaveNewRecords()
{
try
{
if (!Page.IsValid)
{
return;
}
dgTravelPlan.ShowFooter = false;
DataTable ExistingAssociatetbl = new DataTable();
if (Session[AdhocConstants.sessionRequestData] != null)
{
ExistingAssociatetbl = (DataTable)Session[AdhocConstants.sessionRequestData];
ExistingAssociatetbl.Columns[0].AutoIncrement = true;
ExistingAssociatetbl.Columns[0].AutoIncrementSeed = 1;
int IdentityValue;
if (ExistingAssociatetbl.Rows.Count > 0)
{
IdentityValue = Convert.ToInt16(ExistingAssociatetbl.Rows[ExistingAssociatetbl.Rows.Count - 1][0].ToString());
IdentityValue += 1;
}
else
IdentityValue = 1;
AdhocUtility objutility = new AdhocUtility();
GetTravelPlanFooter();
DataRow tblExistingRow = objutility.CreateAssociateRow(ExistingAssociatetbl, FromCity, PickupLocationType, PickupLocation, DropLocationType, DropLocation, PickupDate, PickupTime, ReturnPickupTime, NOD, Disposal, PickupTypeValue, DropTypeValue, FromCityValue, DisposalID, DestinationCityValue, InterCity);
tblExistingRow["Sno"] = IdentityValue;
ExistingAssociatetbl.Rows.Add(tblExistingRow);
if ((CheckDuplicates(ExistingAssociatetbl) == false) & (CheckDateTime(ExistingAssociatetbl) == false))
{
if (IdentityValue == 1)
ExistingAssociatetbl.Rows.Find(Sno = 1).Delete();
ExistingAssociatetbl.AcceptChanges();
Session[AdhocConstants.sessionRequestData] = ExistingAssociatetbl;
dgTravelPlan.DataSource = Session[AdhocConstants.sessionRequestData];
dgTravelPlan.DataBind();
if (strStatus == AdhocConstants.TypeModify)
dgTravelPlan.Rows[0].Visible = true;
else
dgTravelPlan.Rows[0].Visible = false;
btnSubmit.Visible = true;
btnReset.Visible = true;
}
else
{
ExistingAssociatetbl.RejectChanges();
dgTravelPlan.ShowFooter = true;
}
}
}
|
|
|
|
|
rapsrik wrote: if ((CheckDuplicates(ExistingAssociatetbl) == false) & (CheckDateTime(ExistingAssociatetbl)
For me, problem seems to be here, "&" is Unary AND operator and you are using it as Logical AND.
Try to use "&&" operator, its Logical AND operator used in if conditions.
I am not too sure whether it'll solve your problem, but i think error is for that only.
Try it.
|
|
|
|
|
hey thnks dude.. lemme try that
|
|
|
|
|
Please check the following line.
if (IdentityValue == 1)
ExistingAssociatetbl.Rows.Find(Sno = 1).Delete();
Some assignment is happening in the find method when it expects an object . Please check it.
"Never put off until run time what you can do at compile time."
- David Gries, in "Compiler Construction for Digital Computers", circa 1969.
|
|
|
|
|
Hi,
(1) If you have any access to "event viewer" of the hosting server, did you get any exception details there or any more information?
(2) I have seen you have provided a big code block, however did you identify which line it is causing the exception?
if you can do that it would be great so that we can help you more.
Thanks,
Arindam D Tewary
|
|
|
|
|
Hey hi..
this block actually
if (ExistingAssociatetbl.Rows.Count > 0)
{
IdentityValue = Convert.ToInt16(ExistingAssociatetbl.Rows[ExistingAssociatetbl.Rows.Count - 1][0].ToString());
IdentityValue += 1;
}
and also.. the stack exception shows error in this method too..
and the line is marked with two **
private bool CheckDuplicates(System.Data.DataTable dtCheckDuplicates)
{
DataTable dtDuplicateRecords = dtCheckDuplicates.Clone();
bool blnCheckDuplicate;
for (int iRow = 0; iRow <= dtCheckDuplicates.Rows.Count - 1; iRow++)
{
blnCheckDuplicate = false;
** string strCheckRow = string.Empty;
object[] arr = dtCheckDuplicates.Rows[iRow].ItemArray;
for (int iColumn = 0; iColumn <= arr.Length - 1; iColumn++)
{
if (dtCheckDuplicates.Columns[iColumn].ColumnName.Trim().ToUpper() != "SNO")
{
if (iColumn != arr.Length - 1)
strCheckRow += dtCheckDuplicates.Columns[iColumn].ColumnName + " = '" + arr[iColumn].ToString() + "' and ";
else
strCheckRow += dtCheckDuplicates.Columns[iColumn].ColumnName + " = '" + arr[iColumn].ToString() + "'";
}
}
if (dtDuplicateRecords.Select(strCheckRow).Length > 0)
{
blnCheckDuplicate = true;
}
if (!blnCheckDuplicate)
{
DataRow[] drs = dtCheckDuplicates.Select(strCheckRow);
if (drs.Length > 1)
{
lblError.Text = "";
lblError.Text = AdhocConstants.DuplicateTravelPlan;
return true;
}
}
}
return false;
}
thnks for the help..
|
|
|
|
|
I've never done search-related.
the search-content contains: musics,pictures,peoples etc.
so I have a few questions.
Search content from multiple tables and multiple Fields.
I do full-text indexing of these fields.
If I need to create a view that contains these fields?
then I write sql "select" from this view.
is right?
I hope someone can give a guiding learning resources.
Thanks.
|
|
|
|
|
Hi,
I wan`t to use URL rewriting to map my requests to other page. for eg:
http://mydomain.com/101120/54623/Invoice_14235.zip
to
http://mydomain.com/Download.aspx?a=101120&b=54623&c=Invoice_14235.zip
Can anybody suggest how this can be done more efficiently and are there any microsoft tools (3rd party is not allowed in my project).
Any suggestions wold be welcomed.
When you fail to plan, you are planning to fail.
|
|
|
|
|
|
Hi all,
In my application i am opening a window through javascript from the code behind on the click event of an asp button.
But the problem is when i am placing the button inside an update panel the window is not opening.otherwise it is working.
Can anybody give me any way to solve it.
|
|
|
|
|
Are you Registering any startup event for the Button in the codebehind to open the window?
If yes, ClientScript class would not work in UpdatePanel. You ScriptManager's Register function.
|
|
|
|
|
its because when postback occurs it removes javascript so to resolve this problem you require to register click event of the button again.
For more help : pranayamr.blogspot.com
|
|
|
|
|
Can you post your code snippet? This will help us in answering..
Cheers!!
Brij
<a href="http://www.codeproject.com/KB/aspnet/asp_net4_0_URLRouting.aspx">Check my latest Article :URL Routing with ASP.NET 4.0</a>
|
|
|
|
|
|
|
thanks and cheers........
Rating always..... WELCOME
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
|
I m working on DataList. I have added one DropDownList in HeaderTemplate od DataList
<headertemplate>
|
|
|
|
|
Hi,
I am working with the HTTP Post method to log the user into my framework. But when I run the page it does not redirect to the Page given in URL. What I am doing wrong?
Following is my code:
string strResponse;
string strPost;
protected void Page_Load(object sender, EventArgs e)
{
strPost = "txtUserName=abc&txtPassword=123";
UTF8Encoding objUTFEncode = new UTF8Encoding();
byte[] arrRequest = null;
Stream objStreamReq;
StreamReader objStreamRes;
HttpWebRequest objHttpRequest;
HttpWebResponse objHttpResponse;
Uri objUri = new Uri("http://www.mysite.com");
objHttpRequest = HttpWebRequest.Create(objUri) as HttpWebRequest;
objHttpRequest.KeepAlive = false;
objHttpRequest.Method = "POST";
objHttpRequest.ContentType = "application/x-www-form-urlencoded";
arrRequest = objUTFEncode.GetBytes(strPost);
objHttpRequest.ContentLength = arrRequest.Length;
objStreamReq = objHttpRequest.GetRequestStream();
objStreamReq.Write(arrRequest, 0, arrRequest.Length);
objStreamReq.Close();
CookieContainer cookieContainer = new CookieContainer();
objHttpRequest.CookieContainer = cookieContainer;
//Get response
objHttpResponse = objHttpRequest.GetResponse() as HttpWebResponse;
objStreamRes = new StreamReader(objHttpResponse.GetResponseStream(), Encoding.ASCII);
strResponse = objStreamRes.ReadToEnd();
objStreamRes.Close();
}
Thanks
|
|
|
|
|
Dot-Net-Dev wrote: What I am doing wrong?
First, you are not following the guidelines for posting here. Use the pre tags to format any code you post.
Of course it's not redirecting because you are not telling it to. All you are doing is writting, or attemtpting to, the content of the web request to the output stream of the same page. This is NOT the way to a redirect. Use Response.Redirect.
This is also not the way to authenticate users. I suggst you read up on forms based authentication.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
hi,
I am trying to use user control event in the aspx page. I have two textboxes txt1 and txt2. txt1 is in user control(ascx) page and txt2 is in aspx page. Now with ascx page, i have one popup calender say calender1 too. Now when i click that calender1, both textboxes should show the selected date. How to do that? I can show the date in the textbox txt1 but how to do it for txt2?
thanks
suchita
suchita
|
|
|
|