SPQuery trouble - ASP.NET Discussion Boards

Re: what is Difference between filestream and memorystream

eyeseetee28-Jul-08 4:13

eyeseetee

28-Jul-08 4:13

http://www.google.co.uk/search?hl=en&q=filestream+and+memorystream+in+asp.net&btnG=Google+Search&meta=

Soap Call to a Webmethod platform

Anoop Unnikrishnan28-Jul-08 2:26

Anoop Unnikrishnan

28-Jul-08 2:26

How to make a SOAP Call from ASP.Net to a WebMethod platform.

Thanks & Regards
Anoop Sigh | :sigh:

Creating a gridview programatically in asp.net 2.0

vijaylumar28-Jul-08 2:21

vijaylumar

28-Jul-08 2:21

i want to create a gridview programmatically

i want to add a template column and edit that template column and place a label in item template column

can i do it thru coding.....

thank u inadvance
vijay

Re: Creating a gridview programatically in asp.net 2.0

Sherin Iranimose28-Jul-08 3:43

Sherin Iranimose

28-Jul-08 3:43

Have a Look here[^]

Online Test Creation

kalyanapu28-Jul-08 2:15

kalyanapu

28-Jul-08 2:15

hi,

I am designing Online Test Creation Using asp.net(C#). in that question display should be like this;
.....................Question..................... ........
O opt1
O opt2
O opt3
O opt3

prev next (buttons)

my questions and Options had saved in two Sql tables.

Question(idquestion,Qname,Answer,Qtype) idQuestion is primary key

Answer_Detail(idAnswerDetail,idquestion,options) idAnswerDetail is primary key and idquestion is Foreign Key

how can i display one question at a time randomly, if i have 100 questions in my database. on next button click i have to get another question and on previous button click i have to go back to previous button. which control i have to use for this one. i have to select one radio button among given following four options.

i used grid view,details view ..etc but i could not get the above format..

my requirement:
1)display one question at a time randomly, if i have 100 questions in my database. on next button click i have to get another question and on previous button click i have to go back to previous button.
2) the selected option should be saved to database table. because i have Previous Test page in which i have to show all the previous tests Taken, along with all the questions in that test with which option user was selected during test
3)i have to maintain a timer....

please give suggestion on coding...

how to use user control in more two user controls.

lakshmichawala28-Jul-08 1:38

lakshmichawala

28-Jul-08 1:38

iam having three user controls in say uc1,uc2,uc3.iam using this uc1 in ,uc2 and uc3 .where in uc1 iam having a gridview.now iam taking these controls in another web page.the problem is the grid is recognised in the uc2.but it is not recognising in the uc3 .it is genarting a script error .object is required, how this problem is solved.

Re: how to use user control in more two user controls.

eyeseetee28-Jul-08 2:18

eyeseetee

28-Jul-08 2:18

So youve got a gridview which can be shown in two pages but not the ohter?
Im a bit confused as to what you are trying to do, please reword your question.

SPQuery trouble

Hakmeh Mohannad28-Jul-08 1:33

Hakmeh Mohannad

28-Jul-08 1:33

hi all
i dont know where to put this question but i think it would be here

i have the following SPQuery which it get its result from custom list inside sharepoint site

SPList splTerrorism = spsw.Lists[NaussLists.AttackedEntityName];
SPQuery spqTerrorismQuery = new SPQuery();
spqTerrorismQuery.Query = @"<Query><Where><And><And><And><And><And>";
spqTerrorismQuery.Query += "<And><And><And><And><Geq><FieldRef Name='DateOfAction' />";
spqTerrorismQuery.Query += "<Value Type='DateTime'>" + txtFrom.Text + "</Value>";
spqTerrorismQuery.Query += "</Geq><Leq><FieldRef Name='DateOfAction' />";
spqTerrorismQuery.Query += "<Value Type='DateTime'>" + txtTo.Text + "</Value></Leq></And>";
spqTerrorismQuery.Query += "<Contains><FieldRef Name='Country' /><Value Type='Lookup'>" + AllCountries + "</Value>";
spqTerrorismQuery.Query += "</Contains></And><Eq><FieldRef Name='City' /><Value Type='Lookup'>" + ddlCity.SelectedItem + "</Value>";
spqTerrorismQuery.Query += "</Eq></And><Contains><FieldRef Name='OperationName' /><Value Type='Text'>" + txtActionName.Text + "</Value>";
spqTerrorismQuery.Query += "</Contains></And><Contains><FieldRef Name='AttackingEntityName' />";
spqTerrorismQuery.Query += "<Value Type='Lookup'>" + AllAttackers + "</Value></Contains></And><Contains><FieldRef Name='AttackedEntityType' />";
spqTerrorismQuery.Query += "<Value Type='Lookup'>" + AllAttacked + "</Value></Contains></And><Contains><FieldRef Name='AttackedEntityName' />";
spqTerrorismQuery.Query += "<Value Type='Text'>" + ddlAttackedEntityName.SelectedItem + "</Value></Contains></And><Eq><FieldRef Name='WeaponType' /><Value Type='Lookup'>" + ddlWeaponType.SelectedItem + "</Value>";
spqTerrorismQuery.Query += "</Eq></And><Contains><FieldRef Name='ActionType' /><Value Type='Lookup'>" + AllActions + "</Value></Contains></And></Where></Query>";
SPListItemCollection splic = splTerrorism.GetItems(spqTerrorismQuery);

the problem is that all the list is displayed no matter what the value are even if there is no values at all

note : i made this CAML Query with U2U CAML Query Builder

Thank you

Not considering "If condition in inside the foreach statement" [modified]

Member 387988128-Jul-08 1:13

Member 3879881

28-Jul-08 1:13

Hi my code not at all considering the if condition:

Plz whats wrong in that code tell me...,

foreach (DataRow drc in DS.Tables[DS.Tables.Count - 1].Rows)
{
int k = 0;
while (k < drc.Table.Rows.Count)
{
if (drc.Table.Rows[k][1].ToString() == Path.GetFileNameWithoutExtension(d.Name))
{
if (mbody.Length > 0)
{
mbody += ", ";
}
mbody += drc.Table.Rows[k][1].ToString();
}
k++;

}

}

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

modified on Monday, July 28, 2008 6:32 AM

Re: Not considering "If condition in inside the foreach statement"

Blue_Boy28-Jul-08 1:50

Blue_Boy

28-Jul-08 1:50

this
if (drc.Table.Rows[k][1].ToString() == Path.GetFileNameWithoutExtension(d.Name)) is always false?

Or if (mbody.Length > 0) return always 0 (zero) length ?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: Not considering "If condition in inside the foreach statement"

gaurav mangal28-Jul-08 3:24

gaurav mangal

28-Jul-08 3:24

hi sir

plz tell us why it will give false and 0 lenth always?

thanks....
gaurav

Re: Not considering "If condition in inside the foreach statement"

Blue_Boy28-Jul-08 5:59

Blue_Boy

28-Jul-08 5:59

Because maybe he didn't debug his code.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: Not considering "If condition in inside the foreach statement"

Sherin Iranimose28-Jul-08 4:23

Sherin Iranimose

28-Jul-08 4:23

New one wrote:
DS.Tables[DS.Tables.Count - 1].Rows

If there is only one Table in the DS always, Why cant you use a DataTable.

New one wrote:
drc.Table.Rows[k][1].ToString()

Set a break point a check what value is there in the above code.

percentage signs around sql parameter

eyeseetee28-Jul-08 1:08

eyeseetee

28-Jul-08 1:08

Hopefully an easy one guys
Need to put % signs around an sql parameter in a stored procedure
something like %@value%

anyone have any ideaS?
thanks

Re: percentage signs around sql parameter

Blue_Boy28-Jul-08 1:15

Blue_Boy

28-Jul-08 1:15

this works for me in SQL 2000

CREATE PROCEDURE SpName AS<br />
<br />
declare @paramVal as varchar(4000)<br />
set @paramVal='value'<br />
select * from TableName where columnName like '%'+@paramVal+'%'<br />
GO

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: percentage signs around sql parameter

eyeseetee28-Jul-08 1:28

eyeseetee

28-Jul-08 1:28

Thanks that worked!
Smile | :)

Re: percentage signs around sql parameter

Blue_Boy28-Jul-08 1:30

Blue_Boy

28-Jul-08 1:30

You are welcome dude Wink | ;)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

OnClientClick

Reelix28-Jul-08 0:44

Reelix

28-Jul-08 0:44

Hi all!

I've been using the OnClientClick with the Button control for awhile now to execute JavaScript without causing page validation:

Button1.OnClientClick += "javascript:doThis(); return false;";

but one thing still eludes me...

Is it possible to execute the OnClientClick event on a textBox?

If anyone can figure out any solution, I would be highly grateful!

-= Reelix =-

Re: OnClientClick

Blue_Boy28-Jul-08 1:08

Blue_Boy

28-Jul-08 1:08

try
TextBox1.Attributes.Add("OnClick", "javascript:alert('This is just sample');");

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: OnClientClick

Reelix28-Jul-08 1:11

Reelix

28-Jul-08 1:11

Thanks!

Works perfectly! Big Grin | :-D

-= Reelix =-

Re: OnClientClick

Blue_Boy28-Jul-08 1:16

Blue_Boy

28-Jul-08 1:16

You are welcome.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

sqlbulk copy asp.net c#

VijayVishwakarma27-Jul-08 23:20

VijayVishwakarma

27-Jul-08 23:20

Hi,

i am inserting records from a datatable to sql server 2005 database using sqlbulk copy.
The problem is that the datasource datatype is different from sql server table datatype.

Is there any way to convert the datatype to there corresponding datatypes in the table.

thanks

Re: sqlbulk copy asp.net c#

VijayVishwakarma28-Jul-08 1:04

VijayVishwakarma

28-Jul-08 1:04

no one has the answer???????????

Vijay V.

Re: sqlbulk copy asp.net c#

Ashfield28-Jul-08 2:12

Ashfield

28-Jul-08 2:12

Usually I import into a staging table where every column is a varchar, then validate the contents to the real data type before moving them to the actual destination table. This gives you a chance to perform other validation too.

Bob
Ashfield Consultants Ltd

Re: sqlbulk copy asp.net c#

VijayVishwakarma28-Jul-08 21:10

VijayVishwakarma

28-Jul-08 21:10

HI,

is there any way to detect that what kind of value is there in an .csv file rows??

thanks

Vijay V.

Yash Softech

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.