ASP.NET

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 22:13

<pre lang="HTML"><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
AutoGenerateEditButton="True" BackColor="White" BorderColor="#336666"
BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowdatabound="GridView1_RowDataBound" onrowediting="GridView1_RowEditing"
Width="770px">
<Columns>
<asp:BoundField DataField="Vehicle_Booking_Date"
DataFormatString="{0:dd-MM-yyyy}" HeaderText="Date" HtmlEncode="False" />
<asp:TemplateField HeaderText="From">
<EditItemTemplate>
<MKB:TimeSelector ID="TimeSelector1" runat="server" DisplaySeconds="False">
</MKB:TimeSelector>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server"
Text='<%# String.Format("{0:t}", Eval("Time_From")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="To">
<EditItemTemplate>
<MKB:TimeSelector ID="TimeSelector2" runat="server" DisplaySeconds="False">
</MKB:TimeSelector>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server"
Text='<%# String.Format("{0:t}", Eval("Time_To")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="KM Start">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("KM_Start") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("KM_Start") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="KM End">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("KM_End") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("KM_End") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Used By">
<EditItemTemplate>
<asp:DropDownList ID="ddlUser" runat="server" DataTextField="UserName"
DataValueField="Sno">
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Bind("Vehicle_Used_By") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Cost Code">
<EditItemTemplate>
<asp:DropDownList ID="ddlCost_Code" runat="server" AutoPostBack="true"

onselectedindexchanged="ddlCost_Code_SelectedIndexChanged"
AppendDataBoundItems="True">

<asp:ListItem Value="0">-Select-</asp:ListItem>

</asp:DropDownList>

</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%# Bind("Cost_Code") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Budgetline">
<EditItemTemplate>
<asp:DropDownList ID="ddlBudget_Line" runat="server" >
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label7" runat="server" Text='<%# Bind("Budget_Line") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

</Columns>
<FooterStyle BackColor="White" ForeColor="#333333" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White"
HorizontalAlign="Left" />
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="White" ForeColor="#333333" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />

</asp:GridView></pre>

Karthik Harve3-Mar-13 22:23

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 22:23

update the edit template as below.

ASP.NET

<asp:TemplateField HeaderText="Cost Code">
    <EditItemTemplate>
        <asp:DropDownList ID="ddlCost_Code" runat="server"   AutoPostBack="true"        
        onselectedindexchanged="ddlCost_Code_SelectedIndexChanged"
        AppendDataBoundItems="True">        
        <asp:ListItem Value="0">-Select-</asp:ListItem>        
        </asp:DropDownList>
        
        <asp:Label ID="lblCostCode_Hd" visible="false" runat="server" Text='<%# Bind("Cost_Code") %>'></asp:Label>
    
    </EditItemTemplate>
    <ItemTemplate>
        <asp:Label ID="Label6" runat="server" Text='<%# Bind("Cost_Code") %>'></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

take one hidden label "lblCostCode_Hd" which hold the selected Cost Code. and in row databound add below code.

ddlCost_Code.DataSource = dt_for_CostCode;
ddlCost_Code.DataTextField = "Cost_Code";
ddlCost_Code.DataValueField = "Proposalno";
ddlCost_Code.DataBind();

Label lbl = (Label)e.Row.FindControl("lblCostCode_Hd");
if(lbl != null)
{
    ddlCost_Code.Items.FindByText(lbl.Text).Selected = true;
}

so, this will select the particular code which you have selected.

hope it works.

Vande Matharam - Jai Hind

demoninside93-Mar-13 22:27

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 22:27

it is working and showing the sected value. but when I change it by selection another item in dropdownlist , it auto select the last selected item itself. this is the main issue

Karthik Harve3-Mar-13 23:23

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 23:23

try by making AutoPostBack = false.

Vande Matharam - Jai Hind

demoninside93-Mar-13 23:35

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 23:35

I need selectedindexcahged event for some work, without AutoPostBack = true it is not possible.
So I need to keep this property to true. By the way I tried by making it false but the same result I got, it didn't give the solution

Karthik Harve3-Mar-13 23:38

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 23:38

check in any of the events you are rebinding the grid again ?, because rebinding the grid will make the dropdownlist to select the previous value.

Vande Matharam - Jai Hind

demoninside93-Mar-13 23:53

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 23:53

after selecting an item from ddlCost_Code selectedindexchaged fires then the whole page posbacks and I am binding the grid on page_load event.

Karthik Harve3-Mar-13 23:59

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 23:59

So, Since you are re-binding the grid, Row_databound is firing, and dropdownlist is also re-binding and the default value is selecting. so, handle the dropdownlist selected index changed evnet, but do not rebind the grid, or else, before binding check the edit index whether edit index is equal to -1 or not. if EditIndex = -1, then bind the grid, otherwise leave as it is.

Vande Matharam - Jai Hind

demoninside93-Mar-13 23:57

Re: dropdownlist auto select first value in gridview with edit mode

3-Mar-13 23:57

Thanks you so much Karthik Harve. Actually I was forget to remove the page prerender event, which i wrote for some test.

Thanks
Gaurav

Karthik Harve4-Mar-13 0:04

how to make multiple entries for a book in database for multiple copies of the same book in a library?

4-Mar-13 0:04

Welcome Gaurav. Happy coding .!! Smile | :)

Vande Matharam - Jai Hind

Madhubala Ganesan2-Mar-13 6:33

Madhubala Ganesan

2-Mar-13 6:33

Hi..I am currently working on a project on Library Management System. I ve created a database to store the books in the Library. While adding books, i want to add multiple copies of the same book. i need to create a unique book ID for each book..how can i make multiple entries of the same book wid different IDs for each?

eg., Book name: Engineering Thermodynamics
Author: P K Nag
Publisher: ABC
Edition: 2
Category: Mechanical Engineering
Quantity: 5

i need to add this data to the database making 5 different entries for the same book wid a unique ID. Plz help me!

Re: how to make multiple entries for a book in database for multiple copies of the same book in a library?

Bernhard Hiller3-Mar-13 20:35

Bernhard Hiller

3-Mar-13 20:35

You need two tables, one describing the book, and one for each copy. The latter references the former, using the ID of the book description table as a foreign key.

Json + asp.net

jojoba20112-Mar-13 4:45

jojoba2011

2-Mar-13 4:45

when i run like this :

testing.com/test.aspx?query=select top(60000) * from [dbo].tblTesting

the source is :

<pre lang="c#"><pre lang="c#">

<%@ Page Language="C#"%>
<%@ Import Namespace="System.Collections.Generic" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Web.Script.Serialization" %>
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System" %>

<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{

using (SqlConnection cn = new SqlConnection("Data Source=127.22.125.11,1985;Initial Catalog=Test;uid=testing;pwd=123456"))
{
using (StreamReader sr = new StreamReader(Request.InputStream, Encoding.UTF8))
{
Response.ContentType = "text/plain";
string c;
c = Request.QueryString["query"]; //for debugging with the browser
//you can set the query by adding the query parameter For ex: http://127.0.0.1/test.aspx?query=select * from table1
if (c == null)
c = sr.ReadToEnd();
try
{
SqlCommand cmd = new SqlCommand(c, cn);
cn.Open();
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List<dictionary<string, object="">> list = new List<dictionary<string, object="">>();
while (rdr.Read())
{
Dictionary<string, object=""> d = new Dictionary<string, object="">(rdr.FieldCount);
for (int i = 0; i < rdr.FieldCount; i++)
{
d[rdr.GetName(i)] = rdr.GetValue(i);
}
list.Add(d);
}
JavaScriptSerializer j = new JavaScriptSerializer();
j.MaxJsonLength = Int64.MaxValue;
Response.Write(j.Serialize(list.ToArray()));

}
catch (Exception ex)
{
Response.TrySkipIisCustomErrors = true;
Response.StatusCode = 500;
Response.Write("Error occurred. Query=" + c + "\n");
Response.Write(ex.ToString());

}
Response.End();
}
}
}
</script>

the error is :

Error occurred. Query=select top(60000) * from [dbo].tblTesting<br />
System.InvalidOperationException: Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.<br />
   at System.Web.Script.Serialization.JavaScriptSerializer.Serialize(Object obj, StringBuilder output, SerializationFormat serializationFormat)<br />
   at System.Web.Script.Serialization.JavaScriptSerializer.Serialize(Object obj, SerializationFormat serializationFormat)<br />
   at System.Web.Script.Serialization.JavaScriptSerializer.Serialize(Object obj)<br />
   at ASP.test_aspx.Page_Load(Object sender, EventArgs e) in testing.com\test.aspx:line 44

Re: Json + asp.net

jkirkerx4-Mar-13 10:36

jkirkerx

4-Mar-13 10:36

jojoba2011 wrote:
System.InvalidOperationException: Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.

There is a limit on the max length of a JSON returned, you can adjust it in the web.config

<system.web.extensions>
   <scripting>
     <webServices>
       <jsonSerialization maxJsonLength="50000000"/>
     </webServices>
   </scripting>
 </system.web.extensions>

As for the reason for the super long JSON returned,

In my opinion, I would of created a web service, called test.asmx, and return a formatted JSON result, and then parsed it. But what do I know, I have no clue what your trying to do.

Re: Json + asp.net

jojoba20119-Mar-13 17:58

jojoba2011

9-Mar-13 17:58

thanks a lot!
can give me a small example webservice json?
i am doing for mobile so when i press update button ,it should go to the main server and get all info (new and old and updated infos).
how to do that?

Re: Json + asp.net

jkirkerx9-Mar-13 18:19

jkirkerx

9-Mar-13 18:19

I write in vb, not sure if that helps, but

<WebMethod()> _
    <ScriptMethod(ResponseFormat:=ResponseFormat.Json)> _
    Public Function Get_RateVendorCode( _
        ByVal rate_API_Code As String,
        ByVal localization_Code As Integer) As String

        Dim sb_json As StringBuilder = New StringBuilder
        Dim json_response As String = Nothing

        Dim Rate_VendorCode As String = ""
        Dim service_Marks As String = ""
        Dim service_Title As String = ""

        Try
            Dim rm As ResourceManager = Nothing
            Dim ci As CultureInfo = Nothing

            Select Case localization_Code
                Case 0
                    rm = New ResourceManager("SC_Standard.labels_en", Assembly.GetExecutingAssembly())
                    ci = New CultureInfo("en-US")
                Case 1
                    rm = New ResourceManager("SC_Standard.labels_fr", Assembly.GetExecutingAssembly())
                    ci = New CultureInfo("fr-CA")
                Case 2
                    rm = New ResourceManager("SC_Standard.labels_es", Assembly.GetExecutingAssembly())
                    ci = New CultureInfo("es-MX")
            End Select

            Rate_VendorCode = Get_RateVendorCode_SQL(rate_API_Code)

            Select Case Rate_VendorCode
                Case "DHL"
                    service_Title = rm.GetString("Select Rate:")
                    service_Marks = rm.GetString("DHL service marks used by permission")

                Case "FEDEX"
                    service_Title = rm.GetString("Select Rate:")
                    service_Marks = rm.GetString("FedEx service marks used by permission")

                Case "FEDEXFREIGHT"
                    service_Title = rm.GetString("Select Rate:")
                    service_Marks = rm.GetString("FedEx service marks used by permission")

                Case "UPS"
                    service_Title = rm.GetString("Select Rate:")
                    service_Marks = rm.GetString("UPS service marks used by permission")

                Case "FREIGHTQUOTE"
                    service_Title = rm.GetString("Select Rate:")
                    service_Marks = rm.GetString("FreightQuote.Com service marks used by permission")
            End Select

        Catch ex As Exception

        End Try

        sb_json.Append("{")
        sb_json.Append(" ""VendorCode"" : """ & Rate_VendorCode & """,")
        sb_json.Append(" ""ServiceTitle"" : """ & service_Title & """,")
        sb_json.Append(" ""ServiceMarks"" : """ & service_Marks & """")
        sb_json.Append("}")

        json_response = sb_json.ToString

        Dim js As System.Web.Script.Serialization.JavaScriptSerializer = New System.Web.Script.Serialization.JavaScriptSerializer
        js.Serialize(json_response)
        js = Nothing

        Return json_response

    End Function

error '80004003', Object reference not set to an instance of an object.

notahack2-Mar-13 4:37

notahack

2-Mar-13 4:37

hopefully i am posting in the correct section.

I have created a class in c# to replace a vb6 class used in an asp web page. Note I said asp and not asp.NET. I am running this in IIS 7.5 on a 64 bit Windows 7 machine.

I compiled the program and all its support dlls as x86 and believe I got all the correct tags and check boxes for COM. I can create and use the class in VB6 but it still bombs in vbscript with can't create object. I found some articles on going to do tweaks in the registry to get it to work on 64 bit but alas no avail.

The web application will run with the old VB6 object just fine. The configuration is an application with a separate pool set to pipeline mode classic, no managed code, enable 32 bit applications = true;

Initially I was getting a can not create object when trying to use the new c# object but I copied the dll and its support dlls to the sysWOW64 directory and it changed it's tune to

MaxRecall.Shared error '80004003'

Object reference not set to an instance of an object.

/mr/mrq.asp, line 193

the structure of the project is thus

the object I am creating with createobject is dependent on a single assembly, MaxRecall.CORE, which is dependent on two assemblies, MaxRecall.CLIENTS and MaxRecall.Shared. None of the support assemblies are com exposed so this error is not a COM error at all I think.

MaxRecall.Shared is totally static with zero objects to create. It only had two static doubles that were class scoped that were not instantiated but I set them to 0 in their declarations. To my thinking there are no objects in MaxRecall.Shared to gain an instance to so the error is odd.

Sigh. Any and all insights are desperately welcomed. I cross posted this in the COM section.

Re: error '80004003', Object reference not set to an instance of an object.

Richard MacCutchan2-Mar-13 5:42

Richard MacCutchan

2-Mar-13 5:42

notahack wrote:
I cross posted this ...

Please don't; see point 1 here[^].

Use the best guess

plugging in twitter and facebook into the web application

Member 87018131-Mar-13 3:04

Re: plugging in twitter and facebook into the web application

1-Mar-13 3:04

can anyone help me how to plug in facebook & twitter into the webapplication (c# asp.net4.0)...pls help me

Sandeep Mewara1-Mar-13 4:24

Sandeep Mewara

1-Mar-13 4:24

Using OAuth you can implement the login's for these social networking sites.

For Facebook:
Facebook: OAuth Dialog[^]
Using Web APIs with OAuth 2.0[^]

For Twitter:
Sign in with Twitter[^]
OAuth FAQ[^]

Sample - FB & Twitter: C# Application Integration with Facebook & Twitter with oAuth[^]

Sandeep Mewara
Microsoft ASP.NET MVP 2012 & 2013

[My Blog]: Sandeep Mewara's Tech Journal!
[My Latest Article]: HTML5 Quick Start Web Application

Re: plugging in twitter and facebook into the web application

Member 87018131-Mar-13 8:32

Re: plugging in twitter and facebook into the web application

1-Mar-13 8:32

https://developers.facebook.com/apps[^]
when i click the above link i am getting logon page,but not "create new app" button....pls could u tell me where it is...i am trying to identify for the past 3.30 hrs....but couldn't find....i am not getting clear picture....still trying to understand it...

Facebook: OAuth Dialog[^]
 Using Web APIs with OAuth 2.0[^]

the above links....not able to understand...any help is appreciated...
same is d case with twitter

Sandeep Mewara1-Mar-13 9:04

Sandeep Mewara

1-Mar-13 9:04

Member 8701813 wrote:
when i click the above link i am getting logon page,

Member 8701813 wrote:
the above links....not able to understand...any help is appreciated...

Article with code and sample were shared. If you are unable to understand it, it would be difficult for me to make you understand online. I would suggest you to catch someone in person - a senior or a teacher.

Sandeep Mewara
Microsoft ASP.NET MVP 2012 & 2013

[My Blog]: Sandeep Mewara's Tech Journal!
[My Latest Article]: HTML5 Quick Start Web Application

Re: plugging in twitter and facebook into the web application

Member 87018132-Mar-13 21:25

Re: plugging in twitter and facebook into the web application

2-Mar-13 21:25

hi,
when i click on like button the count shold increase ...isn't it?but it is remaining same....
this is the code i added immediately below body tag

XML

<div id="fb-root"></div>
<script>    (function (d, s, id) {
        var js, fjs = d.getElementsByTagName(s)[0];
        if (d.getElementById(id)) return;
        js = d.createElement(s); js.id = id;
        js.src = "//connect.facebook.net/en_US/all.js#xfbml=1&appId=491658267536929";
        fjs.parentNode.insertBefore(js, fjs);
    } (document, 'script', 'facebook-jssdk'));</script>

the follwing code after tag

<div class="fb-like" data-href=="<?php the_permalink(); ?>"  data-send="true" data-width="450" data-show-faces="true"></div>

the following code in web.config

XML

<appSettings>
    <add key="EnableSqlDependency" value="true" />
    <add key="ApplicationId" value="491658267536929" />
    <add key="ApplicationUrl" value="http://localhost:1285/WebSite3/Default.aspx" />
    <add key="ApiKey" value="" />
    <add key="ApplicationSecret" value="506b293633ab728c0516359bce138953" />
    <add key="ExtendedPermissions" value="offline_access" />
  </appSettings>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" />
  </startup>

Member 87018131-Mar-13 23:02