ASP.NET

Re: how to update a gridview using a query from two tables

26-Jul-09 23:03

I suspect you need to write SQL to update your tables.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

haleemasher26-Jul-09 23:08

Re: how to update a gridview using a query from two tables

26-Jul-09 23:08

i write sql query but how i bind it.

<%Bind("Student.Rollno")%>

it doesnot work. it show error that Student is not recognized in this context

Christian Graus26-Jul-09 23:25

Re: how to update a gridview using a query from two tables

26-Jul-09 23:25

You shouldn't have to specify the table, you'd bind to the table that's returned, not tables in the DB.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

haleemasher26-Jul-09 23:31

Re: how to update a gridview using a query from two tables

26-Jul-09 23:31

what should be the bindig code?

Christian Graus26-Jul-09 23:39

how to add a .dll in ur website

26-Jul-09 23:39

Whenever I do this sort of thing, I write my own SQL, I never use the retarded, unprofessional auto data source stuff in ASP.NET. Having said that, I get a source containing the data I need, from however many tables, and I bind to the properties of a struct, or the columns of the table. Just the name of the column or property.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

RajaAhmed26-Jul-09 22:44

RajaAhmed

26-Jul-09 22:44

www.dominion-web.com/applications/flvconverter/

i hve downloaded from this url . can u please help me how to use the dll in my
website using .net

Re: how to add a .dll in ur website

Christian Graus26-Jul-09 23:03

Re: how to add a .dll in ur website

26-Jul-09 23:03

It seems you need to read a REALLY basic book. You add a reference to a dll to your project.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

vid nandha26-Jul-09 23:19

vid nandha

26-Jul-09 23:19

In .net u can see the option Project in menu....in that u just need to do add Reference.....

project -> Add reference

ok....

datagrid

cst200226-Jul-09 22:28

cst2002

26-Jul-09 22:28

how to convert the below coding into vbasp.net code?

TextBox eno=(TextBox)e.Item.FindControl("TextBox1");

Re: datagrid

Christian Graus26-Jul-09 22:30

26-Jul-09 22:30

There are online converters you could use. I don't know how to do the cast, but I'd expect the rest to work just by dropping the semicolon. If you read the MSDN on the FindControl method, that would probably have examples in VB.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: datagrid

Blue_Boy26-Jul-09 22:30

26-Jul-09 22:30

Dim eno As TextBox = CType(e.Item.FindControl("TextBox1"), TextBox)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: datagrid

vid nandha26-Jul-09 23:23

vid nandha

26-Jul-09 23:23

http://www.developerfusion.com/tools/convert/vb-to-csharp/[^]

check this link.......it will help you

auto update gridview

haleemasher26-Jul-09 22:17

26-Jul-09 22:17

i want to enter data using a textbox in gridview. data is successfully enter into database but gridview not show data. when i close the webpage and reopen it then girdview show the data

Blue_Boy26-Jul-09 22:20

26-Jul-09 22:20

When you update data in DB then use DataBind() of GridView.
i.e GridView1.DataBind();

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

haleemasher26-Jul-09 22:30

26-Jul-09 22:30

i simply edit it but i want to auto update gridview. as i click submit button it show that data in gridview

Blue_Boy26-Jul-09 22:34

26-Jul-09 22:34

Your problem is solved or not?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

haleemasher26-Jul-09 22:37

26-Jul-09 22:37

Blue_Boy26-Jul-09 22:40

26-Jul-09 22:40

Without see your code,we can't provide solution.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

haleemasher26-Jul-09 22:48

26-Jul-09 22:48

i have a text box, submit button and a gridview in a same page. by using textboxes i want to enter data in gridview. when i enter data using text box and clik on submit button is show successful entry of data. but girdview is not show the new data which i have entered by textbox. when i close that page and reopen it thn it shows the data which i have entered

Blue_Boy26-Jul-09 22:50

26-Jul-09 22:50

Ok,when you submit that data from textboxes then do you call DataBind method of GridView?
This I asked you in my first reply to your question.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

haleemasher26-Jul-09 22:51

how can i display wikipedia links on my webpage..? [modified]

26-Jul-09 22:51

i use wizard not a bind method.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataKeyNames="TransactionTypeID" DataSourceID="SqlDataSource2" 
            ForeColor="#333333" GridLines="None" 
            style="top: 492px; left: 323px; position: absolute; height: 133px; width: 407px" AlternatingRowStyle-HorizontalAlign="NotSet">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#E3EAEB" />
            <Columns>
                <asp:BoundField DataField="TransactionTypeID" HeaderText="Type ID" 
                    InsertVisible="False" ReadOnly="True" SortExpression="TransactionTypeID" />
                <asp:BoundField DataField="Transaction" HeaderText="Transaction" 
                    SortExpression="Transaction" />
                <asp:BoundField DataField="Description" HeaderText="Description" 
                    SortExpression="Description" />
                <asp:BoundField DataField="Category" HeaderText="Category" 
                    SortExpression="Category" />
                <asp:BoundField DataField="Active" HeaderText="Active" 
                    SortExpression="Active" />
                <asp:CommandField HeaderText="Edit" ShowEditButton="True" />
            </Columns>
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#7C6F57" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConflictDetection="CompareAllValues" 
            ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString15 %>" 
            DeleteCommand="DELETE FROM [TransactionType] WHERE [TransactionTypeID] = @original_TransactionTypeID AND [Transaction] = @original_Transaction AND [Description] = @original_Description AND [Category] = @original_Category AND [Active] = @original_Active" 
            InsertCommand="INSERT INTO [TransactionType] ([Transaction], [Description], [Category], [Active]) VALUES (@Transaction, @Description, @Category, @Active)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [TransactionType]" 
            UpdateCommand="UPDATE [TransactionType] SET [Transaction] = @Transaction, [Description] = @Description, [Category] = @Category, [Active] = @Active WHERE [TransactionTypeID] = @original_TransactionTypeID AND [Transaction] = @original_Transaction AND [Description] = @original_Description AND [Category] = @original_Category AND [Active] = @original_Active">
            <DeleteParameters>
                <asp:Parameter Name="original_TransactionTypeID" Type="Decimal" />
                <asp:Parameter Name="original_Transaction" Type="String" />
                <asp:Parameter Name="original_Description" Type="String" />
                <asp:Parameter Name="original_Category" Type="String" />
                <asp:Parameter Name="original_Active" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="Transaction" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter Name="Category" Type="String" />
                <asp:Parameter Name="Active" Type="String" />
                <asp:Parameter Name="original_TransactionTypeID" Type="Decimal" />
                <asp:Parameter Name="original_Transaction" Type="String" />
                <asp:Parameter Name="original_Description" Type="String" />
                <asp:Parameter Name="original_Category" Type="String" />
                <asp:Parameter Name="original_Active" Type="String" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="Transaction" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter Name="Category" Type="String" />
                <asp:Parameter Name="Active" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString14 %>" 
            SelectCommand="SELECT [Description] FROM [CouponTransaction]">
        </asp:SqlDataSource>

adkalavadia26-Jul-09 22:07

adkalavadia

26-Jul-09 22:07

hi...to all...

I want to display a wikipedia link on my web page on perticular word(i.e. cancer).how can i do?is there any api is provided by wikipedia or any other way..?.Actually all the contents is coming from database.

My content is not static.it comes from database and it can be contain many number of word which are related to medicine/pharmacy.so using <a> tag it will nt possible.how can i do..?

thnxs in advance.

!- F - R - I - E - N - D - S -!

modified on Monday, July 27, 2009 4:17 AM

Re: how can i display wikipedia links on my webpage..?

Christian Graus26-Jul-09 22:11