|
|
Hi friends,
I have a problem with NUnit while checking values with db.
I have created a sql plugin and added it to appropriate addin folder and i can view it under tools->addins->Registered Addins.
whenever i run the a test with the new sql attribute the test is passed
for eg:
[SqlServerDataSource(ConnectionString = "Data Source=DTP00B249\\SQLEXPRESS;Intial Catalouge=sample;Integrated Security=True", Query = "SELECT pword FROM login where uname='paul'")]
public void TestInput()
{
Assert.IsTrue(true);
}
But whenever i pass a value in my method like
public void TestInput(string uname)it throws the Test Not Run Method saying
Method Method name signature is not correct:it must not have parameters.
Please explain how to resolve the error.
thanks in Advance
Praveen
modified on Tuesday, July 29, 2008 9:00 AM
|
|
|
|
|
I am very confused about filestream and memorystream in asp.net
i want to know difference between filestream and memorystream
please try to solve it
|
|
|
|
|
http://www.google.co.uk/search?hl=en&q=filestream+and+memorystream+in+asp.net&btnG=Google+Search&meta=
|
|
|
|
|
How to make a SOAP Call from ASP.Net to a WebMethod platform.
Thanks & Regards
Anoop 
|
|
|
|
|
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
|
|
|
|
|
|
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...
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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."
|
|
|
|
|
hi sir
plz tell us why it will give false and 0 lenth always?
thanks....
gaurav
|
|
|
|
|
Because maybe he didn't debug his code.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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."
|
|
|
|
|
Thanks that worked!
|
|
|
|
|
You are welcome dude 
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
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 =-
|
|
|
|
|
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."
|
|
|
|
|
Thanks!
Works perfectly! 
-= Reelix =-
|
|
|
|
|
You are welcome.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
