Re: Limited Update in Table - ASP.NET Discussion Boards

The you can probably look a for writing a sql query for updating fields. You can run a for loop to check the values and after that fire the sql query only for those columns whose values are changed. DataAdapter.Update may not be a best case in this scenario.

There is no foolish question, there is no final answer...

Here one idea/approach may be using javascript. A javascript function, which will be called on textbox change event (if value changed then) with create and append a update command and then fire that update command on cliking the update button; but i do'nt have knowledge in js; just have the idea how it may worked.

You will not be able to access the value which is set in javascript because on the server side those values will be lost.

There is no foolish question, there is no final answer...

Then please tell me the best and easy method to get update command for selected (changed values) columns.

Kind Regards
Girish Sharma

Then please provide me the solution by which i can get one update command for only those columns whose textbox values has been changed by user.

Kind Regards
Girish Sharma

I already told you this: http://www.codeproject.com/Forums/12076/ASP-NET.aspx?fid=12076&select=3081044&fr=75#xx3081044xx[^]

There is no foolish question, there is no final answer...

But further you are agreeed that adapter.update is not best in this scnerio; so still waiting for your reply please.

I am not telling you to use DataAdapter.Update. Run a for loop and check if the textbox's value differs from the datatable's (dataset.tables[0]) value or not. if it differs then create a sqlconnection object and associate it to a sqlcommand object. Then fire a sql update query by using sqlcommand.executenonquery method. by this way, you will fire sql update for only those rows whose values are changed in the textboxes.

There is no foolish question, there is no final answer...

my code is like tis

tis code works on the same page only i want to set the language setting in all pages.....

Imports System
Imports System.Globalization
Imports System.Threading
Imports System.Resources
Imports System.Reflection.AssemblyName
Imports System.IO

Partial Class Testmultiligual
      Inherits System.Web.UI.Page
            Private rm As ResourceManager

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
                     con.ConnectionString = ConfigurationManager.ConnectionStrings("ESCConnection").ConnectionString
            Dim ci As CultureInfo

            If Not Page.IsPostBack Then

                  gridbind()
                  Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
                  'get the culture info to set the language
                  rm = New ResourceManager("Resources.Strings", System.Reflection.Assembly.Load("App_GlobalResources"))
                  ci = Thread.CurrentThread.CurrentCulture
                  LoadStrings(ci)
            Else
                  'get the culture info to set the language
                  rm = New ResourceManager("Resources.Strings", System.Reflection.Assembly.Load("App_GlobalResources"))
                  ci = Thread.CurrentThread.CurrentCulture
                  LoadStrings(ci)
            End If
      End Sub

Private Sub LoadStrings(ByVal ci As CultureInfo)
            HylEdit.Text = rm.GetString("Add", ci)
            BtnClear.Text = rm.GetString("Clear", ci)
            BtnSave.Text = rm.GetString("Save", ci)
            HylView.Text = rm.GetString("View", ci)
            TDAwd.InnerText = rm.GetString("Awd", ci)
            TDAwdDes.InnerText = rm.GetString("Awddes", ci)
            TDAwdpic.InnerText = rm.GetString("Awdpi", ci)
            TDFreq.InnerText = rm.GetString("Freq", ci)
            TDAwdcri.InnerText = rm.GetString("Awdcri", ci)
            TDAwdSt.InnerText = rm.GetString("AwdSt", ci)
            TDAwdk.InnerText = rm.GetString("Awdk", ci)
            'TDGrvTitle.InnerText = rm.GetString("GrvTitle", ci)

            GVawdview.Columns(1).HeaderText = rm.GetString("AwdNam", ci)

            GVawdview.Columns(2).HeaderText = rm.GetString("Awdesc", ci)
            GVawdview.Columns(3).HeaderText = rm.GetString("Frequcy", ci)
            GVawdview.Columns(4).HeaderText = rm.GetString("Active", ci)

      End Sub

      Protected Sub lnkEng2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkEng2.Click
            Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
            LoadStrings(Thread.CurrentThread.CurrentCulture)
            gridbind()
      End Sub

      Protected Sub LnkEng1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LnkEng1.Click
            Thread.CurrentThread.CurrentCulture = New CultureInfo("es-ES")
            LoadStrings(Thread.CurrentThread.CurrentCulture)
            gridbind()
      End Sub

Was it required to create a new thread to post the same question?

There is no foolish question, there is no final answer...

Please don't Cross Post. Read the forum guide line before post any new question.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Hi all,
I want to user google custom local search in my website.
I dont want to user google serch control for local search.
I want to use my own control in website for that purpose google
provided a search form function and i can't understand how can i
use this. Please help me to solve the problem?

Thanks
Rahul

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Your intention is not clear to me. Do you want to implement search functionality like Google but it search items which only reside in your web site? Or do you want to use Google API to incorporate Google Search functioanlity in your web application?

There is no foolish question, there is no final answer...

I want to incorporate Google custom local Search functioanlity in my website.
check the url maps.google.com and enter any location eg newyork,pune.
you will get some location which contain newyork text in pune city.
I want to use these api in my website but instead of using google search control
i want to use my own control. Using custom form property o API we can create our own
control.I am trying to implement that one.
check this

http://code.google.com/apis/ajaxsearch/documentation/reference.html[^]

hope you will understand.

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

my code is like tis

tis code works on the same page only i want to set the language setting in all pages.....

Imports System
Imports System.Globalization
Imports System.Threading
Imports System.Resources
Imports System.Reflection.AssemblyName
Imports System.IO

Partial Class Testmultiligual
      Inherits System.Web.UI.Page
            Private rm As ResourceManager

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
                     con.ConnectionString = ConfigurationManager.ConnectionStrings("ESCConnection").ConnectionString
            Dim ci As CultureInfo

            If Not Page.IsPostBack Then

                  gridbind()
                  Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
                  'get the culture info to set the language
                  rm = New ResourceManager("Resources.Strings", System.Reflection.Assembly.Load("App_GlobalResources"))
                  ci = Thread.CurrentThread.CurrentCulture
                  LoadStrings(ci)
            Else
                  'get the culture info to set the language
                  rm = New ResourceManager("Resources.Strings", System.Reflection.Assembly.Load("App_GlobalResources"))
                  ci = Thread.CurrentThread.CurrentCulture
                  LoadStrings(ci)
            End If
      End Sub

Private Sub LoadStrings(ByVal ci As CultureInfo)
            HylEdit.Text = rm.GetString("Add", ci)
            BtnClear.Text = rm.GetString("Clear", ci)
            BtnSave.Text = rm.GetString("Save", ci)
            HylView.Text = rm.GetString("View", ci)
            TDAwd.InnerText = rm.GetString("Awd", ci)
            TDAwdDes.InnerText = rm.GetString("Awddes", ci)
            TDAwdpic.InnerText = rm.GetString("Awdpi", ci)
            TDFreq.InnerText = rm.GetString("Freq", ci)
            TDAwdcri.InnerText = rm.GetString("Awdcri", ci)
            TDAwdSt.InnerText = rm.GetString("AwdSt", ci)
            TDAwdk.InnerText = rm.GetString("Awdk", ci)
            'TDGrvTitle.InnerText = rm.GetString("GrvTitle", ci)

            GVawdview.Columns(1).HeaderText = rm.GetString("AwdNam", ci)

            GVawdview.Columns(2).HeaderText = rm.GetString("Awdesc", ci)
            GVawdview.Columns(3).HeaderText = rm.GetString("Frequcy", ci)
            GVawdview.Columns(4).HeaderText = rm.GetString("Active", ci)

      End Sub

      Protected Sub lnkEng2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkEng2.Click
            Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
            LoadStrings(Thread.CurrentThread.CurrentCulture)
            gridbind()
      End Sub

      Protected Sub LnkEng1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LnkEng1.Click
            Thread.CurrentThread.CurrentCulture = New CultureInfo("es-ES")
            LoadStrings(Thread.CurrentThread.CurrentCulture)
            gridbind()
      End Sub

dear all,
i have to maintain the viewstate of page when i m pressing the moveback button,
how do i do that?

Regards

What would you like to store inside the view state?

There is no foolish question, there is no final answer...

Dear All,

Cud any one help me to set the resolution of the web page in asp.net C#?

when i run this site at my client's computer the pages are look much wider.

PLz help

You can set your page to be a fixed width, but of course, then it will not scale for a user with a bigger resolution ( or a smaller one ). If you must do this, then I suggest centering it, so it looks neat when you design for 800x600 and the user is 1900x1600. Of course, the ideal is to go with it, and design your pages so they resize nicely.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Hello guys, is there a way to load a project dynamically using the passed in parameters coming in from VB 6.0 code. Technically the project is not going to get loaded, the idea is that the constrcutor of the Com callable wrapper (that receives the parameters such as Assembly name) will then use the corresponding Web services class library. I wanna be able to call Creator.ActiveInstance() method or some other built in .Net API that can locate the write dll to load based on its name and path.

Any ideas?

Thanks
Tina

Well, whatever you're doing, it's obvious you're not doing it in ASP.NET.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Hello Christian,

Well yes and No...the front end (UI) is all asp .Net but as I said in my original post, it is a COM callable wrapper written in C# that deals with the web services moving forward. Not sure what you are trying to say....but if you are implying that I shouldn't have put it out here, well there wasn't any other category where I'd have this topic.

Also, is there an API (built in .Net class that lets you do that?

Thanks

Hello, no ideas for this yet?...

In my project, I use a javascript function to apply a number formatting mask to my textboxes, using its onKeyUp event.

I want to apply the same function to the textboxes (boundfields) that are shown when the gridview is in edit mode. The gridview is created dinamically, so I need a way to apply my function dinamically.

I already tried the BoundField.ControlStyle.AddAttributesToRender method with no success...

Can anyone help me??

Pehaps there's a better way to do the kind of mask I want, so if anybody knows I'd appreciatte.

Thanks.

Peterson

modified on Wednesday, June 17, 2009 9:19 PM

any ideas?...

Peterson

Hi,

I need to assign the values from date time picker to text box while user choose. also, the text box should not allow user to enter. how can I assign perform this?

Thanks

modified on Sunday, June 14, 2009 9:32 AM