well that is true @table does not have a structure to handle the insert. I guess you are using temporary tables which you can reference like this

create table #TABLE(
employeeid varchar(10),...

hi carobee try this

DECLARE @SqlQuery NVARCHAR(4000);
set @SqlQuery='You query here'
INSERT into @table
exec(@SqlQuery)


regards

Yes, well for now im going to mark this thread as solved once the program is doing what i want, thank your very much for your help if i have another issue i will be around thanks again.

regards.

Ok, Ramesh I think i got it, I use the link you provide to use the preinit but insted of using preinit i use prerender in that case i can execute my code from the master page in the load event in...

Ok, Thanks Ramesh, Actually with your previous comment i got it to do what i want, but the master page load event trigger after the content load event which i would like to run the content load event...

Actually is something like the link you provide here, but i do not have any button to trigger this code it just run in the load page, well the thing is that piece of code is general for every single...

Hi, I would like to know how can I execute an event from a web content form, for example i would like to run a centralized event to assign rigths to component in every webform, but i would like to do...

Hello all, I am looking for a Fax Software, nothing big, easy to use just fax out and in, I do not need any extra feature that a lot of fax software has.

before i had winfax pro is an old software...

I do not know if this can help you, but if you have a date field which you can order by desc, then you can use Top 1 something like this.

Select top 1 Field1
from table1
order by datefield desc...

Got it!!! thanks for your comment.

i see windows 7 crashing with some antivirus, in my case with endpoint protection i couldn't find a way around but install another one.

Hi all, I just have curiosity about something that I read in a book " Unlike using the DataGrid, where you are responsible for
coding the sort routine, to enable column sorting in this grid, you...

Well here i didn't have any trouble doing that, but anyway make sure you have windows firewall off, and run this tool and try again. Norton Removal Tool...

yes sknake you right.

how can I always show a subreport in the second page?
thanks.

thanks for you reply actually i fixed it, I just create a command statement with my query and i map my fields with the old ones and its working now, i guess the fact that i was working with two...

The fields are DefectType, RootType in the Page Header C section and also the details section complete thanks

11524

Hello all, I created a crystal report which works perfect local but in production work partial, it means that there are 3 specific values that the report does no retrieve, is there any particular...

I just update my server to the latest version of symantec endpoint and now everytime i log in to the server a pop up appears with this message, "A necessary file could not be loaded: ccProd" they...

I use querystring to retrieve parameters send from another form, let's say that you are and index.html and there is a link url to default.aspx like this
~/Default.aspx?var=hello

then and the...

That means exactly what is says, probably there is a piece of code that is executed before this method and you leave the connection open. make sure you close the connection on that method. usually i...

Take out the * and try it.

Oops that is true adatapost my bad.
thanks for correcting me.

add this at the end.
DataGridView1.DataBind()

regards

Ok im going to try that, I let you know how it goes.

thanks

Hi all, I have a computer that went down and i cannot load windows but i can browse the files in the hd using an enclosure, i would like to reinstall windows but i need to safe the quickbook data so...

I found what i wanted.

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
PopulateMenu();
}
}...

Into the datagrid's headerstyle property add this
CssClass="ms-formlabel DataGridFixedHeader"
<!-- Then into the head tag create a style method like this -->
<style...

Why dont you include the parameters in the select statement something like

string st = "select user, pass from loggin where user = '"+txtbox1.text+"' and pass = '"+txtbox2.text+"'";
//Then pass...

There is a few good database language out there, but im going to keep it simple.
1) Non free license: Oracle, Sql Server, really nice interface, very user friendly and a lot support online, so you...

Hi, try to add this row in the web.config

<identity impersonate="true"/>

Ok cool.

Hi, check this thread could be helpful for you

http://www.daniweb.com/forums/thread204828.html

in your select statement are you retrieving that value? if yes verify you have autogeneratecolumns to false you have to create a bound column manually for the primary field and also you can set the...

You can use a datatable instead

DataSet dsResult = new DataSet();
DataRow drRev;
DataTable dtRev = new DataTable();
dtRev.Columns.Add("Name");
dtRev.Columns.Add("Number");
For(int i =0; i <...

you need this

if(ContractID_Reader2.HasRows)
{
while(ContractID_Reader2.Read())
{
//Your code here
}
}

you have to do something like this.

foreach (Control cn in form1.Controls)
{
if (cn.GetType().Name == "RadioButton")
{
...

In fact that is the problem that the hyperlinkcolumn does not have the CommandName property.

Ok so then you have to add to the bin folder in your project two dll files System.Web.Extensions.Design.dll and System.Web.Extensions.dll you can find these files under this path usually C:\Program...

Hi, friends i have a datagrid bound a hypercolumn

<asp:DataGrid ID="menu" AutoGenerateColumns="False" Runat="server">
<Columns>
<asp:HyperLinkColumn DataTextField="OPT_DESC"...