|
View a printable version of this message! Hi,
I'm trying to change an MS Access query definition using ADOX in my ASP.NET 2.0 c# web site.
Here is my function:
<br />
public void ModifyQueryXDateFilter( string strConn, string strQryName, string strSQL)<br />
{<br />
ADOX.Catalog catDB = new ADOX.Catalog();<br />
ADODB.Command cmd = new ADODB.Command();<br />
catDB.ActiveConnection = strConn;<br />
cmd = (ADODB.Command) catDB.Procedures[strQryName].Command;<br />
cmd.CommandText = strSQL;<br />
catDB.Procedures[strQryName].Command = cmd;<br />
catDB = null;<br />
}<br />
the line:
catDB.ActiveConnection = strConn;
doesn't work. I get a typically microsoft error that means every thing except the right thing:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Can anyone help with this?
Just Relax And Keep It Simple.
|
|
|
|
|
Hi,
I have an asp:Panel control on my web page. I am using ASP.NET 2.0. When I view source in Internet Explorer and FireFox it is displayed as a div element. When I view source in Opera it is displayed as a table. I don't want a table because it's messing up my layout. What else can I use and what else is recommend?
Brendan
|
|
|
|
|
You can use div instead of asp:panel
|
|
|
|
|
Thanks, that I know I can. It was what I wanted to do first, but I searched Google how to populate a Div with data from SQL Server and could not find any. If you have anything on how to populate a div from the server please let me know.
I tried something like:
<div id="Categories" runat="server"></div>
|
|
|
|
|
You can either put a single text in the InnerText property, or add elements to the Controls collection.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Does a div tag have a controls collection???
Have you got a sample there?
|
|
|
|
|
.NET Enthusiast wrote: Does a div tag have a controls collection?
Yes.
.NET Enthusiast wrote: Have you got a sample there?
Categories.Controls.Add(new LiteralControl("Hello world."));
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
What are you to do? I dont think you can populate a div with data but instead you can populate controls that are in the div.you know what I mean?Let me know in details what you are trying to do so that I can better help you.
|
|
|
|
|
Go and look at www.samarketplace.co.za, look at the categories with their subcategories. Currently, (not online at the moment) I have an asp:Panel and then I populated it (as shown) in the code behond. Ideally I would like to populate a div the same way.
|
|
|
|
|
.NET Enthusiast wrote: I have an asp:Panel and then I populated it (as shown) in the code behond. Ideally I would like to populate a div the same way.
How are you populating the panel? Where is the code you mentioned? What I am suggesting is for you to use a div insetad of a panel to design your page layout.Now for displaying data, you can put a control like a repeater or a grid etc. in the Div and simply bind it.Anyways post your code so we can help.
|
|
|
|
|
You're not getting the point!!!
I mentioned I have a panel. And I populate it just fine. There is nothing wrong with the code behind. What I am tying to say is... The container controls display differently in different browsers. Now it doesn't matter what server control I use, I don't want tables. You understand?
|
|
|
|
|
Bassam Saoud wrote: I dont think you can populate a div with data
Not with "data", but surely with text or controls.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi,
I need to know how I do some thing..
I have FormView in my page and this form is in editMode and have a button ( save ) to save any information changed in FormView
my problem is :
I want to appear a message when the user want to go out without pressing on the save button For example : I have a FormView with edit mode , the user write some thing in this formview and don’t press the save button , then he want to return back to the main page by any button ( back or any other page link ),, here I want to appear this message .. " do you want to save this information " ??
With three choices " yes , no, cancel"
When he press on 'yes' I want to call SqlDatSource.update() to update information And when he press on 'No' I call SqlDataSource.cancel()And when press on 'cancel ' I return to the same page without any event .. How I can do it ??
|
|
|
|
|
hi
you can use a showdialog and show custom form that have these buttons and then perform your program depend on the result of show dialog
sepel
|
|
|
|
|
Thanks for your reply ..
But how I can found show dialog ?? or show custom form ? are these in java script ?
Sorry for my question but because I am beginner in asp.net
Thaanks
|
|
|
|
|
you must add some javascript to onclient click of your buttons.
then in them call showDialog of javascript you need some parameter to return value of dialog result.
function ProductDialog(){
var mytext;
var myvalue;
}
function myShowDialog()
{
ProductDialog.mytext="";
ProductDialog.myvalue="";
if(window.showModalDialog('../Choose.aspx' ,ProductDialog,"dialogHeight:570px;dialogWidth:440px;Scrollbar=1") == true )
{
//do some thing
}
else
{
return;
}
}
in your buttons add this
onclientclick="if (myShowDialog()) return true; return false;"
in form that you showed it
write javascript to access dialog result
window.dialogArguments.mytext = s;
window.dialogArguments.myvalue = node.Value;
sepel
|
|
|
|
|
when we use this overload of fill method od sqldataadapter:
SqlDataAdapter.Fill(DataSet,StratRecord,MaxRecord,TableName)
Imagine we have 1,000,000 record and we want to retrive 20 record from 100 to 120.
we know that DataAdapter itself use DataReader. I want to konw this Fill method retrive only 20 record and return result or retrive 1,000,000 record and thern return 20 of them ?
it is so heavy if retrive all result and return 20 of them.
please guide me. because I want to use this method to paging.
|
|
|
|
|
First of all, you should never implement paging like this. It is incredibly wasteful and inefficient to fetch 1 million records from your database and then discard all but 20 of them. Paging logic should be implemented in a stored procedure so that only the specific page of records you want is returned to your application.
If you are using SQL Server 2005, the ROW_NUMBER function can assist you with paging records. Have a look at this article[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
Hi all,
I have a Gridview within a loginview control, and for some reason I receive the error in the subject line the moment that I click on the edit button of the gridview when I set the property of the gridview AutoGenerateEditButton=true.
Is this because of the Gridview being within another control?
*Modified*
Also, I set the datasource in the codebehind. Basically gridview1.DataSource = new Class().MethodThatComunicatesWithSQL();
gridview1.DataBind();
Might this be the issue?
Any advise or pointers will be greatly appreciated.
Thanks in advance
No matter how long he who laughs last laughs, he who laughs first has a head start!
modified on Saturday, December 15, 2007 1:29:05 PM
|
|
|
|
|
The error means what it says, all those 'auto' methods require you to generate a method in the code behind. Google it and you'll find docs on what the method needs to do.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I did that, and that resolved the error that I received, in the method I have the following :
protected void EditRow(object sender, GridViewEditEventArgs e)
{
try
{
GridView grid = (GridView)LoginView1.FindControl("GridView1");
grid.EditIndex = e.NewEditIndex;
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
But I have to click on the edit button of the GridView twice before I'm able to change the values, is there a way that I can force the page to make another trip to the server?
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
Is anyone else in this boat or am I the only one? I'd like to create a custom Membership Provider, but everytime I get to a certain point in the design, the way MS has implemented everything really limits what you can do! It would have been a 1000 times better if they'd just made all the Membership stuff Interfaces instead of hard classes which they completely designed around their own database and then said "Oh, here's a pattern". Who's pattern? Not mine. Don't think that I am a n00b trying to use Membership for the first time. I've been using and studying it for over a year and a half now.
I'm at the point now where I'd rather just implement the Membership classes from scratch and I'm wondering if anyone else out there has seen anything to this matter.
|
|
|
|
|
Hey guys
I have a very simple question and need a simple solution to it
My GridView Pager is something like...
1 2 3 4 ...
I want it this way...
Page: 1 2 3 4 ...
I know its possible in custom paging or adding some code in code behind. But I need to have it have it without changing code of project, if you help me out. thanks
|
|
|
|
|
Please try with the CSS and display it in the front end. I hope that is one of the way.
Otherwise try to use object datasource and in the custom paging code it as to display page in the fron tend.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|